Tag: SQL Doctor

The right tool for the job

I read a blog post from Brent Ozar (blog|twitter) explaining recent encounters he had with a plumber and an exterminator.  In this post he shows the great service provided by both professionals and that he was happy to pay each professional a prorated rate of about $1,000 dollars per hour. Wow!  How do they make [...]

Parallelism: Stop waiting!

In my previous blog post ‘Parallelism: Hurry up and wait’ I discussed how parallel queries cause CXPACKET waits.  I also covered the common causes for these waits to be high on an OLTP server.  Today I want to finish up my thoughts on the subject and hopefully round out the discussion for both OLTP and [...]

Parallelism: Hurry up and wait

  At the 2010 SQL PASS Summit we had the great pleasure of speaking with the well known SQL Server MVP Pinal Dave (blog).  One of the topics that were discussed was the use of wait stats by SQL doctor for generating recommendations and he agreed to spend extra time with us to discuss his [...]

SQL Doctor encounters ‘The Scary DBA’

Earlier this week a colleague of mine frantically ran up to my desk asking if I had read the SQL Doctor review by ‘The Scary DBA’.  For some reason my initial reaction was to fall backwards out of my chair (almost falling out of the window and squashing the painter that happened to be outside [...]