I remember reading about the development of the NT Operating System, almost 20 years ago.

All developers were required to submit, on average, 250-300 lines of completed, tested source code...

Steve,

I can certainly envision a query that might benefit from having the best possible plan generated although I can't in my experience recall such a query, maybe because such option...

I've worked in shops where formal documentation was required for all code and it had to be maintained.

I've worked in shops where developers insisted that the best and only...

A lot of good experience has been written for finding problem queries on this thread. The experiences can be summed up by saying that for a person to identify potential...

After reading Jeff's post, I think I'll revise my strategy for dealing with problem queries.

It's a lot more efficient than mine.

:hehe:

Eric,

If your users claim the server is slow, I would do several things:

> Ask them, "Compared to what?" This is not a smart *** question. It's a realistic question about...

There are so many ways to find problem queries; it's hard to elaborate all of them.

When I first get on a server that is new to me, I perform...

I don't have a lot of good stories in my career about companies' dedication to performing root cause analysis and problem resolution.

So many companies and CIO's I've worked for had...

I've seen code reviews required in some shops, little or none in others.

An old adage applies: "An ounce of prevention is worth a pound of cure." Sometimes 10 pounds, if...

Nice art work, Jeff. For once, someone used a font that was large enough for me to read it.

But you are off subject. We are talking about 2 different things....

My last DBA position was in the Operations part of a DevOps shop.

The company's implementation of DevOps was a colossal failure in several respects:

1. The ROI for the huge...

The question is great but I liked the answers better.

All, nice answers.

I think this is the final word on the correct and appropriate setting for MAXDOP: http://support.microsoft.com/en-us/kb/2806535

Having spent 20+ years as a software engineer programming in 10 different, 2nd through 5th generation, software languages, I have a good understanding of the paradigm differences between computer software...

Henrik,

Have you experimented with data compression, both at the row and page level?

I'm created significant storage efficiency improvements at the page level but those results involved a lot of...