SQL Server with Mr. Denny:

SQL Server


January 25, 2013  6:10 PM

Recommended reading from mrdenny for January 25, 2013



Posted by: Denny Cherry
SQL Server, Top 10

This week I've found some great things for you to read. These are a few of my favorites that I've found this week.

January 23, 2013  9:00 AM

NOLOCK is not a turbo button



Posted by: Denny Cherry
CREATE INDEX, Database, Execution Plans, Indexing, SELECT statement, SQL Server, T/SQL, Tables

All to often when talking to developers they put the WITH (NOLOCK) table hint in place to speed up queries without understanding what the table hint does.  I've even run across companies that have policies in place that every select statement must have the WITH (NOLOCK) table hint. The WITH...


January 18, 2013  6:17 PM

Recommended reading from mrdenny for January 18, 2013



Posted by: Denny Cherry
SQL Server, Top 10

This week I've found some great things for you to read. These are a few of my favorites that I've found this week.