Seems like a bad idea to name a proc go, even if you can do it. Good to know what happens, but bad practice...

Andy,

Well done! The pattern you used is similar to patterns I've used through the years, would like to see if there is a different implementation in SQL 2008? ...

I think it's a pretty good question, would like to see more xml questions!

Peter Blatchford (2/27/2009)

---

A couple of posts above suggest relocating the obsolete procs, I'm not sure what the point of that would be, if you've identified that they are obsolete why...

My 02c... Pruning is a good idea, but you need to be sure. it's a pay me now or pay me later deal, if not pruning put them...

Steve,

Did you ever investigate insulating paint? Not sure if it really works or not, but it's said to add some level of insulation.

http://www.hytechsales.com/ceramics/

Mark

Be interesting if they decided to charge per feature, a-la-carte style.

SQL base cost 500.00

Backup compression 100.00

Clustering ...

It's a cool bit of trivia that it works, but not good programming practice- better to name the table something meaningful!

Reminds me of some code I inherited code that used...

Steve,

This was a constant problem when I was teaching at a major university, we had a website we could go to and check to see if there was plagerism going...

Sounds like a company thats pretty foolish! Those employees are not going to be very dedicated!

Adi Cohn (1/26/2009)

---

I think that the answer “You cannot set IDENTITY_INSERT on for more than one table in a database” should be changed to You cannot set IDENTITY_INSERT on...

Well done! Looking forward to part 2...

Man, I hate travelling, nothing goes right for me when I travel. Lost luggage, delays, missed connections!

Steve,

As a general rule, I backup to a different file every time - the only exception would be if I'm working in Dev or test to do an ad-hoc backup...

Nice article!

Lots of good advice, I particularly like the advice about learning T-SQL... and the fact that Cursors have their place, and DBA code is one of the places where...