Everything Steve said.

Plus, another way to cut costs is to volunteer for the PASS organization, bust your hump, and earn a free admission to the conference. It's not easy, but...

blandry (11/18/2008)

---

I apologize in advance for my comments (a little bit), and mean no insult directly at any DBA but...

Do you ever take a moment and think about how many...

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.