Thanks for posting this Paul. It's great fun!

Terry

I explode. Then I reintegrate and clean up the mess.

I prefer fiction (sci-fi and fantasy) although some non-fiction creeps in sometimes. Probably 20-30 books a year. Most from the library in paper form. I have an original iPad and...

thanks!

really enjoying the articles, well done on the blitzing!

The links to the Security and the Reliability columns are the same so I can't get to the Reliability article.

Thanks a lot! That looks like something to try.

Terry

I get nothing when I click on t-sql. Does that happen with anyone else?

Thanks Benjamin... that summary is very useful.

We've noticed that only 1 of the 8 cores on our server is running and only 300 Mb of 32 Gb was being used during a particularly long running stored...

We're mainly using SQL Server 2005 SP3 but we have a few instances of the RTM of SQL Server 2008 on a Vista desktop and some Vista laptops; we found...

Does anyone know when Microsoft are going to release SQL Server 2005 SP2?

Your reply fits not

the rhyming scheme

report me to SOx not

or I will scream

You're supposed to croon

Johnny's Cash's tune

I'm still SA

you'll have to pay

Ok... I'll take your challenge Gianni!

I keep a close watch on this data o' mine,

I keep a process running all the time.

I keep the locking low so it won't bind

Since...

I would do it the manual way (make everyone dbo's of their own db's and all members of the master db)... or script it for one user and then parameterize...

A way around the backup issue is to use Windows Scheduled Tasks. Micheal Otey from SQL Server Magazine had an article about this although I can't seem to find...