Viewing 15 posts - 21,961 through 21,975 (of 22,194 total)
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...
March 26, 2007 at 9:09 am
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...
March 26, 2007 at 8:27 am
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...
March 26, 2007 at 6:25 am
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.
March 23, 2007 at 6:47 am
You're going to have to do a lot more work in order to convert from that form of string.
One problem that I...
March 22, 2007 at 10:14 am
SELECT * FROM tblCandidates
WHERE 1 = CASE WHEN @CandidateId = 0 THEN 1
WHEN ID_Kandidat = @CandidateID THEN 1
ELSE 0
March 21, 2007 at 10:31 am
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...
March 21, 2007 at 6:16 am
But, of course, never on a production system where we need to have up to the minute data recovery, right.
March 20, 2007 at 1:35 pm
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...
March 20, 2007 at 9:11 am
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...
March 20, 2007 at 8:36 am
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...
March 20, 2007 at 7:02 am
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...
March 20, 2007 at 7:00 am
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...
March 20, 2007 at 6:41 am
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...
March 20, 2007 at 6:22 am
#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...
March 19, 2007 at 11:57 am
Viewing 15 posts - 21,961 through 21,975 (of 22,194 total)