Viewing 15 posts - 1 through 15 (of 36 total)
tolga.kurkcuoglu (9/13/2012)
It looks like it, unneccessarily, computes the dateadd function for each row.
you might...
September 13, 2012 at 9:20 am
patrickmcginnis59 (6/21/2012)
I freely admit that I'd like to be biased toward portability in the general case, but that it would take additional effort to materialize that bias in specific efforts.
I...
June 21, 2012 at 7:57 am
patrickmcginnis59 (5/31/2012)
Grant Fritchey (5/31/2012)
I'm with you. Fast enough is fast enough.
But, I remember when a friend of mine (wish I could say I did this) spotted a problematic query in...
May 31, 2012 at 11:59 am
Grant Fritchey (5/31/2012)
May 31, 2012 at 8:30 am
Berl (3/30/2012)
Although CPU time difference is not very great, the difference is much bigger for the elapsed time.
Elapsed time includes wait time and is not a good measure of...
March 30, 2012 at 4:21 pm
Possibly easier is to use COALESCE, which doesn't have this problem. COALESCE is also more flexible.
February 1, 2012 at 10:02 pm
Syed Jahanzaib Bin hassan (7/12/2011)
Change the compatibility mode to 100 and rebuild the indexes and update the stats also,did you ?
I haven't tried that - change compatibility to 100, indexes/runstats,...
July 12, 2011 at 7:04 am
Eric M Russell (3/21/2011)
I'm not interested in an academic point of view about SQL; it's their job to constantly argue anything. As a professional database developer, an actual practitioner, what...
March 21, 2011 at 12:23 pm
bob mazzo (3/17/2011)
I have been considering changing the READ UNCOMMITTED TO READ COMMITTED (which I understand to be the Sql Server default).
I only put the UNCOMMITTED...
March 17, 2011 at 2:01 pm
Am I missing something here?
The fundamental problem is running at READ UNCOMMITTED. No READ UNCOMMITTED, no problem.
If you're getting this error, you a reading uncommitted transactions.
Also, a thought:
FROM filter_list flst,...
March 17, 2011 at 9:52 am
I'm with Kevin on this one.
If you're running SQL Server out of lock space, your problem isn't a lack of memory, it's that you're running something that takes and...
March 17, 2011 at 9:00 am
It just occurred to me that NoSQL may, in fact, be the answer. The problem is that few people advocating it understand the question.
March 15, 2011 at 11:30 am
The primary trouble I've seen with the NoSQL movement so far is that a large portion of those who are migrating to it are using it because they don't understand...
March 14, 2011 at 11:14 am
This is useful. I only have to do this once in a while, and I've been using clumsier methods.
January 12, 2011 at 6:03 am
I don't know why people would mark this article down, but people are funny sometimes.
Even though I probably won't use this technique (I can't think of a time when I've...
November 15, 2010 at 7:10 am
Viewing 15 posts - 1 through 15 (of 36 total)