Viewing 9 posts - 1 through 9 (of 9 total)
Thanks for your help Wildh.
Checking data for contraints using sql tasks is good suggestion but I have lots of tables involved and that would mean checking all tables and all...
January 7, 2004 at 10:18 am
Thanks DavidBurrows for your response.
Details:
I have two types of tables some having a serogate key as PK and some having composit PK consisting of 4 columns. They all have FKs...
October 24, 2003 at 9:57 am
In this perticular situation we already have dates stored in free-text format as we are doing some extract from Pervasive 2000i database.
The execution plan does show the diffrence but probably...
October 20, 2003 at 12:11 pm
In this perticular situation we already have dates stored in free-text format as we are doing some extract from Pervasive 2000i database.
The execution plan does show the diffrence but probably...
October 20, 2003 at 12:11 pm
In this perticular situation we already have dates stored in free-text format as we are doing some extract from Pervasive 2000i database.
The execution plan does show the diffrence but probably...
October 20, 2003 at 12:11 pm
In this perticular situation we already have dates stored in free-text format as we are doing some extract from Pervasive 2000i database.
The execution plan does show the diffrence but probably...
October 20, 2003 at 12:11 pm
The data type of both the fields (field_1 and field_2) is varchar and the index create was a clustered index.
Execution Plan: Though is show 2% on the "Select" in query#2...
October 20, 2003 at 10:54 am
quote:
The first will be slightly faster assuming it uses no implicit conversions. An exact equivalence will also be faster than a...
October 20, 2003 at 10:02 am
Viewing 9 posts - 1 through 9 (of 9 total)