I like the idea of "a hacking competition across a couple hours at a SQL Saturday or conference.". As part of performance tuning courses we used to corrupt the students...

I agree with Steve, a regular Service Pack, every year for the supported life of the product. That would mean Service Pack 4 is that last for SQL Server 2008....

I agree with Gsquared - UTC is the way to go.

If you have ever had to move servers across the world or dealt with daylight savings then a common...

Excellent set of scripts and reports. Easy to deploy. Great work.

Steve - you only listed 6 continents. You missed Australia. If you can endure the plane flight I am sure that the SQL Server community here will welcome you with...

I have spent the last 12 months helping to relaunch a music subscription download service. This allows you to download as much as you like per month. I always encourage...

Steve - have you ever thought about not sending a newsletter on the weekend, but combine it into a larger Monday newsletter. If there is something exceptional then send out...

Encryption besides being annoying and pointless, it can also be dangerous if you lose the source code (a malicious attack by a disgruntled employee about to leave). Also I always...

Cost of unleaded petrol in Sydney, Australia is around $1.60 per litre (or over $7 per gallon). Depends what day of the week you buy it on as the service...

I am currently in the situation where I have been explicitly asked (and contractually forced) not to post or blog any SQL Server information that may be considered intellectual property...

As a "consultant" I usually only accept assignments within my area of expertise. Most of the time I will say to my potential clients that what they require is not...

Had the same error message and problem.

Added the following to fix:

@query_result_no_padding =1

Hope this helps.

Had the same error on a SQL 2005 server that had a stored proc that used a cursor that enumerated the user databases then ran a SQL command against each...