SQL Consulting: SQL Server Is Our Only Business.
posted on
The September issue of this newsletter has been easy to write. It is to let you know that the long-awaited book from Grant Fritchey about understanding SQL Server Execution Plans is now available. It …
Continue Reading about Understanding SQL Server Execution Plans →
posted on
I was surprised by the response to last month's article introducing a practical methodology for query optimization. We received more complimentary emails for this article than for any other article we …
Continue Reading about SQL Server Tuning – The Covering Index →
posted on
And avoiding the Performance Problems they Bring SQL Server developers have to do their work in two different worlds. In one world they use modern, object oriented languages where things like code …
Continue Reading about Understanding Unsearchable Arguments →
posted on
Having been called in many times when an enterprise has lost all its data I can assure you that on arrival it is a dismal scene. Blame goes all around but it is usually the DBA who ends up getting …
posted on
The Enterprise Edition of SQL Server is much more expensive than the Standard Edition, about $20,000 more expensive per license. Microsoft can get this price because Enterprise Edition contains …
Continue Reading about Before You Upgrade to SQL Server Enterprise Edition →
posted on
For performance reasons, clustered indexes are necessary on almost all tables. We assume that the reader is aware of this. This article isn’t going explain the why’s and wherefore’s of that statement. …