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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy