Might be good if you had multiple filegroups and multiple temp tables you were gonna join?;)

I've seen some instances where even going into single-user mode doesn't work... but if you take the DB offline it does.

Q. When you take the DB offline does it...

Excellent Article!

I've been a generalist for a long time - in fact when I first started contracting in IT, I would take a development gig then take an infrastructure gig...

Pretty good article and code... Well done!

I once had a gig where I could telecommute 2 days a week. Saturday and Sunday 🙂

Nowadays telecommuting is becoming more popular, gas here is over 4.00 a gallon with...

Eric Inman (6/2/2006)

"Table Variables are more performant than temp tables because they don't use tempdb."

From my experience I have seen table variables still built into tempdb. Do some simple testing...

In general, it's a good idea to reduce the surface area of a server by disabling unused services. This includes Reporting Services, integration services, IIS, etc....

Agreed!

It's too late to change it, IMO it was a bad idea from the beginning. Still would rather see a warning or error message, rather than silent truncation.

Seems like logically it should throw an error. This one to me is kind of dangerous, if some data happens to be bigger than expected you could end up...

Seems like the 'right' answer is to redesign the DB.

Having inherited designs like this most likely the reason for the design is to provided the flexibility to add new attributes...

Good Article!

I think 'Good' depends on your needs. Good depends on what you need for the job.

Over the years I've made the same observation.

I play the bass guitar, and have IT friends who are guitarists, drummers and keyboard playerz. Kinda funny how that works out...

Steve,

Thanks for the podcasts! They are both informative and entertaining!

I especially liked the recent 'boycott' one; it makes you think.

Generally, I try to steer away from new releases in...

Pretty useful - I use these all the time. Just beware it can take a long time and create alot of locks when you reindex!

Regarding clustered indices -

I think 99.99999999999% of the time you're better off having one...

It can help when you defragment that table.

I think one example where clustered indices might not...