Search results for query: *

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, 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, 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, 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, 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, the password of my User is expired, because I should change it every month, but when using a script I did not noticed that. Is there any possibility to log on to the database now, without the help of the dbc user ? sincerly jack