1) 5 is universally a bad number for cost threshold for parallelism. You get WAY too many parallel queries, especially in OLTP scenarios.

2) MAXDOP on the server should almost...

HAH!! Yep - that is about all I use for "logical"...

My statement about making "queries" faster is about the ENTIRE process. The act of populating a temp table with an index already on the temp table before data is...

I can count on 1 hand the number of times in 15+ years of SQL Server consulting that I have come across client actions involving temp tables where an index...

I will make 1 "improvement" to Gail's recommendation on MAXDOP. Check your hardware, and if it is NUMA (almost all modern servers are) then set the SQL Server MAXDOP...

WHERE [DateTime] < DATEADD(hour, 48, @MaxBuffer), or something similar to that. Could be >, didn't dig too deeply into it.

Luk, you have been going at this problem for over 10 days now. Give me or another good professional 15 minutes on your system and you will have a...

dmoldovan (12/11/2012)

---

My customer is running a small e-commerce site on a SQL Server 2008 R2 SP2 Workgroup Edition x64. The SQL Server runs on a Windows Server 2008 R2 Standard...

I wonder if the plan is EXACTLY the same between the parallel and non-parallel executions. I would imagine that one is doing an index seek and bookmark lookup for...

Guras (12/11/2012)

---

I was thinking of writing two sub proc based on the finclass value. There will be a wrapper sp that takes the finclass values and based on that I...

Here is a 3-part blog post about deadlocking from Bart Duncan: http://blogs.msdn.com/b/bartd/archive/2006/09/09/deadlock-troubleshooting_2c00_-part-1.aspx

This is going to get you a BAD cached plan. No matter which...

Dr. David DeWitt is the one person that I would never miss as a keynote speaker.

This can be found in BOL:

1) IF UPDATE(b) OR UPDATE(c) ...

2) IF ( COLUMNS_UPDATED() & 2 = 2 )

This type of performance tuning and analytics is what I (and a few others here on the forums) do for a living. There are a WIDE range of potential...