Jeff Moden (2/26/2010)

---

Sounds like a monty python leadin ;-);-)

Jeff Moden (2/26/2010)

---

Jason... you might also want to try Gianluca's enhancement with the original "seed" using UNPIVOT. Between what he came up with, your original work, and Tom's enhancement,...

You're welcome

Tom.Thomson (2/26/2010)

---

I can cut somewhere between 0.2 and 4 per cent off the elapsed time at 150000000 rows for Jason's method (but limiting scalability to 4 billion rows instead of...

extraneous

murph_32952 (2/26/2010)

---

Rename potentially obsolete objects by appending a "z" or "zzz" to the front of the object name. If the object is required, someone will get an error. ...

hypochondriac

Kit G (2/26/2010)

---

lmu92 (2/26/2010)

---

I'm not sure if it's because of my lacking language skills... but all I understood was CLOUDS ...

Is anybody able to tell me what he was...

jswong05 (2/26/2010)

---

Query tuning, indexing should be done at least once at dev, at QA before pushing to production environment. The execution plan should be evaluated. If you are serious, you...

Thanks - i needed that wiped clean 😉

Hygienical

Here's an article...

Reclaim the space within the file. Backing...

I've seen it a few times. And now you can say that you have heard of that. 😀

Sarab. (2/26/2010)

---

You can restore the backup of pub DB with another name (can be myDB)

but if you have a DB already created, it is not at all possible to restore...