Search results for query: *

The main question is how often do you need the data from Sybase, if you need it just once, use the import / export wizzard of SQL Server (in Management Studio: on Servername -> right mouse click-> import / export. If you need it regulary, you can use the mentioned SSIS method, or maybe even...

Hi, when backuping transaction logs I want to realize some error handling. But if during the backup the share is renamed the error handling ist not working anymore. I read that a few errors are not catched by "try error", I think this kind of operation system error can not be catched by...

Hi, is there a script to find all "not enforced referential relationsships" in a database, based on data analysis? There are tools for DB2 which can do that, and I wonder if someone programmed a similar script for SQL Server 2005. thanx in advance. br farhy

Hi, this is a 64Bit cluster do you know such a behavior. My theory is: When a checkpoint occurs, all the pages in the ram (200GB) must be checked if the dirty bit is set, therefore one cpu go up to 100% for 15 sec. If a request is scheduled to this cpu, it takes much longer, than usual. Can...

hi, we have a SQL Server 2005, on a multi cpu computer with 200 GB ram and, during a Checkpoint we have 100% cpu load on a single processor. Has anyone seen such a behavier on SQL Server 2005 or do you have a computer with similar high ram without this problem? Is there any posibility to bind...

Hi, is there a possibility to see all Reports of the users, on which they have rights? thanks in advance. farhy

Hi, I want to change the source of a Table in Designer: is it possible that all referencing aliases in this universe reference to the new Table? When deleting the table, all aliasis are deleted too. thank you in advande farhy

Hi, I have two time dimensions in a fact-table: eg: FK_Date_ID_Sold_at FK_Date_ID_Imported_at FK_Product_ID Value If I join the table with two differnt Time tables, (alias on Time table) I get the data doubled. How can I handle the two time dimensions in BO, without creating two...

Hi Dieter, thank you very much, I tried this it takes about 50 mins. But I found a better solutions, with takes 10 mins on Oracle 9i, the secret was a hash join. Create table tmp1 as SELECT /*-+ PARALLEL(a,8) USE_HASH(a p) */ a.ROWID AS myrow , a.called_no , p.Destination_Tag FROM CDRs a...

Hi, you have to join nine tables to get this result set. Here is the SQL Stmt to get 3 rows. Select T0.* , T1.NM1 , T2.NM2 , T3.NM3 FROM ORD T0 left outer join DTL T1 on T0.ORD_ID=T1.ORD_ID left outer join DTL T2 on T0.ORD_ID=T1.ORD_ID left outer...

Hi, I have a table A (=30 Mill Record) with a String, that I want to compare with a table B (200 Records). I want to find the longest String from B that matches with the String from A. My Solution: Select Case When Substr(A.StringA,1,3) = (Select B.Substr from B Where...

Hi, here a few fragments, you could need: 1) link Bussiness Objects into your project Dim bo As busobj.Application Dim boDoc As busobj.Document Set bo = CreateObject("BusinessObjects.Application") bo.LoginAs Set boDoc = bo.Documents.Open("c:\myBoFile.rep") boDoc.Refresh sincerly farhy

Hi, I have one dimension and 2 values, say the amount of this year and the year before. Then I create a variable to get the percentage. Now I want only all the values, that are greater than 10%, how can I get this? Custumer_name amount_a amount_b percentage Thanks everyone. farhy

Hi, I would like to know, where to find online SQL Puzzles, or a advanced how to "SQL". There are some books (Celko, ...), but are there some online resources? Thanx in advance farhy

Hi, there are many ways to do this: You can user MS Access with linked tables, both DB2 and Oracle. Other programs like : DBArtisan from Embacadero (there is a evaluation version of it) SQLways can also handle this task. so long farhy

Hi, when I try to connect to tera data, I get the an error "[TCP/IP Vendor][WSOCK32 DLL] 10054 WSA E ConnReset: Connection reset by peer" What can I do to solve this? sincerly fari

Hi, I composed a few mindmaps for my Tera Data certification. have fun :-) http://www.wu-wien.ac.at/usr/h99a/h9926260/teradata/ so long farhy

Hi, 1) that is mostly a question of favor, Mr Kimball he would recommend the denormalized schema, NCR recommends an ER Modell, with Join Indexes, Global Temp. tables, etc. (even for datamarts :-) ) From my point of view the denormalized design is suitable for datamarts. 2) Read the Design...

Pinan, I also try to get my TeraData Certification, please would you tell us, how you did prepare ? so long farhy

Hi, I am also learning for Tera Data Certification, but I didn´t find any useful ressources, beside the ncr homepage. But have a look at: http://teradata.uark.edu/doc2.html so long farhy