Thank you Steve for sharing some very insightful reflections.  With the benefit of hindsight, we often are able to see the good that comes from experiences that are not good,...

I agree with the comments here - the code as written will produce variable results as the separate GETDATE functions are evaluated. This can be avoided by getting and...

Thanks for your article - great overview and intro. I tried to give you five stars, but clicked the wrong star; SSC doesn't seem to allow a way to...

Thanks, Tom for the clarifications. There are several references out there that simply state 'When a table contains a FILESTREAM column, each row must have a nonnull unique row...

Great checklist - thanks for compiling!

One note about Compatibility Level - this really hinges on the applications. Of course, you need to test in advance on the new SQL...

I have to disagree with your answer. You simply said you want a fifth row. Doing a simple insert, as you did at the start, is the fastest...

Agree with prior comments - the question was not clear. Recommended memory is 4GB, except for Express editions which is 1GB. The question did not state express edition,...