Excellent article. Well written. Good advice. Practical and straight forward. Keep it coming.

You have to take into account the fact that you are either instantiating a connection or pulling one out of the connection pool. This will also add some overhead to...

Read the question again. My answer, based on the question, is pretty...

The reason there probably aren't that many articles comparing performance between the two is because they're meant to substitute one for the other. INTERSECT is meant to find the distinct...

Excellent. Glad I could help. Thanks for posting what the correct answer was too. It'll be useful if people searching for the same issue find this in the future.

wschampheleer (2/10/2010)

---

Grant Fritchey (2/10/2010)

---

wschampheleer (2/10/2010)

---

pink_panther,

Thank you for the compliment.

Unfortunately, I believe your new version is no improvement: you still need to insert the old ID if you want to retrieve...

wschampheleer (2/10/2010)

---

pink_panther,

Thank you for the compliment.

Unfortunately, I believe your new version is no improvement: you still need to insert the old ID if you want to retrieve it using the...

sql_lock (2/10/2010)

---

Grant,

In my example, no (as sql is just changes the pointers to the meta-data). But to answer with the original post in mind then yes you would need to...

Huge topic. Someone should write a book.

Execution plans, in short, are how SQL Server determines how it will access your data. They are reused if the query you're submitting matches...

Test, test, test. Introducing constraints into a system that had none previously will, in all likelihood, lead to errors. Go slow. Try to identify the areas of data that are...

You can only insert into one table at a time as far as the TSQL commands are concerned. But as the last post showed, if you wrap these inserts in...

Don't you also have to set up partitioning between these tables first? I'm asking because I've never used...

Another option is to use the OUTPUT clause to capture the generated ID's and then use them in the inserts in the second table.

You can get different execution plans if the connection settings are different. Check the ANSI settings in particular.

Based on the query, you're probably getting pretty severe table scans. But I agree with the previous post, make sure your statistics are up to date.

Can you post the execution...