Viewing 15 posts - 1 through 15 (of 26 total)
My experience broadly echoes Glenn's recommendation; off for OLAP, on for OLTP. But, as you mention in the article no two workloads are ever the same.
These sorts of scenarios...
January 23, 2011 at 6:47 am
I've done both in the past.
In some organisations we've added a 'SystemDB' which is used for general purpose logging, supplementary backup info, capturing occasional profiler traces etc. For views...
November 5, 2010 at 7:29 am
Table variables are not inherently slower than temp tables. The issue lies in the optimiser evaluating them as always having a small number of rows, IIRC < 10. That aside,...
November 4, 2010 at 5:24 pm
You're getting various inappropriate and/or plain inaccurate suggestions thrown in here.
yes, true set the maxdop to 1 will decrease the utilization of cpu usage.
No. There can be circumstances where you...
November 2, 2010 at 3:43 am
john 64806 (10/17/2010)
October 18, 2010 at 7:38 am
The common table expressions used are an alternative to using temporary or derived tables, hopefully making the query easier to understand by breaking it down into smaller parts. Hastily put...
September 21, 2010 at 5:36 am
This tweaked my interest on the train journey home this evening. Extension/merge of the two previous suggestions, using the script to generate data that ColdCoffee kindly added but using perm...
September 20, 2010 at 1:16 pm
Exactly the same issue (and bizarrely almost identical counts from Profiler and QA) cropped up here recently. I've been scratching my head and getting no where so far.
June 11, 2007 at 5:23 am
Apparent blocking problems post SP4 are bound to be http://support.microsoft.com/default.aspx?scid=KB;EN-US;906344
June 11, 2007 at 5:20 am
While you should generally run the tuning wizard as a matter of course as the first step with performance problems, you have to remember that it can only tell you...
November 17, 2006 at 4:48 am
If there isn't a policy to stop 'really bad' articles being published on SQLServerCentral, there should at least be one that stops said articles appearing in the "One year ago..."...
September 28, 2006 at 8:33 am
Have no issue with the advertisements myself, you're perfectly entitled to do whatever is necessary to earn a crust! Would however agree that they may work better on the opposite...
September 7, 2006 at 10:21 am
Tom mentioned it but I didn't see a response, have you checked the execution plans on both servers to see if there are any differences between the servers?
February 23, 2006 at 3:18 am
I'm starting to wonder if some of the people in the "DRI is stupid" camp are mis-understanding what is meant by referential integrity. Some posters in the original thread seemed...
February 14, 2006 at 6:06 am
Litespeed and Sonasafe are both worth investigating.
January 26, 2006 at 8:46 am
Viewing 15 posts - 1 through 15 (of 26 total)