I think you're correct on my errors in the article. Thanks for the input. I'm not sure if Steve will let me do an update, but I'll check.

I suspect it's...

What about scans & I/O? Are they on identical servers? What about weirder stuff like tempdb usage or log backups or other processes causing locks, etc.

Still, the difference between...

I experimented and came up with this:

USE

tempdb;

IF EXISTS (SELECT *...

The only answer I have for you is the one that I'm dealing with at this company. They want the "code" tables to be the same across all applications and...

Allow me to say right up front, I don't like this standard. I inherited it. I fought against it. I lost.

We name our simple lookup tables 'C_WhatEver' and the complicated...

By and large I've stayed away from XML in the database for all the reasons that most people here can list. I have found that XML can play a part...

Two single quotes inside of single quotes. So if it's part of a string, it looks like this:

'There''s a single quote'

If you were just inserting a quote:

''''

Because:

''

Is an empty string.

 You're going to have to do a lot more work in order to convert from that form of string.

One problem that I...

SELECT * FROM tblCandidates

WHERE 1 = CASE WHEN @CandidateId = 0 THEN 1

WHEN ID_Kandidat = @CandidateID THEN 1

ELSE 0

Whew. I thought I was going nuts for a minute when that turned out not to be as easy as I originally thought. We all came to the same conclusion...

But, of course, never on a production system where we need to have up to the minute data recovery, right.

100,000 records is just going to take a long time to return especially when you add x number of columns, latency, network traffic, etc. It's also probably going to ignore...

OK. Maybe I'm wrong.

I tried several things and the original is still the performing best.

I thought this would work:

SELECT *

FROM x

WHERE 1 = CASE WHEN '' = @id THEN...

Oh yeah, I'd go with XML. It's a bit of a pain to code, but you can make it scream (except for the memory overhead) for performance. It directly supports...

First, the low hanging fruit. Is the column Enquiry_Id an integer (most ID columns are, why I'm asking)? If so, it looks like you're passing a string & letting it...