Lynn Pettis (11/17/2009)

Everyone is looking at the values, yes, they are "different",...

I think getdate() = getutcdate() would return false in your time zone, so I think they're probably different!

A good example of the need for thorough testing 🙂 Would rather not have a mark against me on the stats for answering correctly though 🙁

Oops, my bad... 2005 seems so far away now 🙂

... or use merge.

I reckon this thread has pretty much said all it's going to :doze: Credit to the QOD author; fair point to (some of) the criticisms; let's call it a day.

It may have been the intention to design the question in that way, but nothing in the question shows its heart to be about extensions any more than it is...

try SELECT '''' + @str + '''' 🙂

I'd warn against routing backups to a central location and from there to other locations. The source of the data (the database server) is a bottleneck you can't avoid. The...

The other point to consider is whether the backup file was compressed by Sql Server (Enterprise/Dev edition only). If not, depending on the computing power available and the capacity/capability of...

... or see http://www.ssmstoolspack.com/Main.aspx

I take your point about it being good exercise for the mind - quite so. But in the real world, if you rely on the database behaving in a particular...

I reckon it's a good example of bad practice just because the outcome isn't defined 🙂