NOCOUNT and User Options

Recently we had a vendor suggest to us that we turn off the option for NOCOUNT on their database. Upon hearing this my first question was, naturally, why? What was the issue such that they would say they wanted this turned off for their database(s)? Those questions were immediately followed by, naturally, how? How do … Read more

SQL 2008 Book by Grant Fritchey

Grant Fritchey’s new book is now available on Amazon, you can order it from the link below. SQL Server 2008 Query Performance Tuning Distilled I have know Grant for a few years now and have always been impressed with how he able to dissect query plans as well as his overall performance tuning abilities. This … Read more