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...

David Portas (2/10/2010)

---

Not if you use a compound...

David Portas (2/10/2010)

---

Grant Fritchey (2/10/2010)

---

If you go with the arc, there's nothing inherently evil in it. It's not a good design, but the world won't come to an end if...

Dave Winchester (2/10/2010)

---

Hi Grant

Thanks for the reply. Your explanation has helped me (mentally) greatly. I understand the Person/Location etc...relationship better now.

With regards to my problem of the Comments tables for...

Yeah, they frequently do. You have to remember that costs in query plans are just estimates, not real numbers. They can be...

I'm on board with Welsh Corgi, make sure you're testing your backups.

Other than that, it seems like a reasonable plan. I'd just run the log backups for 24 hours though....

Roy Ernest (2/9/2010)

---

Thanks for standing up for me 🙂 I appreciate it very much.

This is the first time I got insulted here. Feels kind of strange... But what ever.....