Flat out, if you're not parameterizing the queries in some method, through stored procedures, through the code, or through parameters defined in sp_executesql, you are almost...

Just plucking out the relative bits:

'Cannot create a file when that file already exists.'...

Here's a set of methods on how you can deal with versioned data. Instead of a GROUP BY, I'd suggest using a TOP 1 with an ORDER BY....

A yahoo email address, so I suspect spam too.

However, in the interest of being nice, Christmas time & all...

We try to help out here as much...

This is where things get fun.

Defining what "correct" results look like is very entertaining. I've worked with people who put WITH NO_LOCK on every single query in the...

Combine Joe's answer with Lynn's answer and you're most of the way there.

To get the precise size of the log you're going to have to do some testing...

To implement RCSI there really isn't anything you need to do to your code. It's the more traditional snapshot isolation that requires code changes. As Perry already stated, this will...