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...

There's no doubt that XML does add overhead, but from the sounds of things, you're probably well within the range that justifies it's use. What kind of functionality is it...

Do you mean that you've passed in more than 2100 parameters? If that's true, you might want to change your calls and send in XML that you can shred on...

#1 DBA Response: It depends.

Honestly, some production systems don't need up to the second transaction recovery so we set the recovery model to simple. Some production systems, we care about...