About SQL Nuggets

The primary focus of SQL Nuggets is to offer useful tips for developers and other IT professionals who are using SQL Server…

Read More…

Subscribe

Enter your email address to subscribe to the SQL Nuggets blog.

Recent From the Blog

NOLOCK may not be doing what you think it does

When working with developers, I’ve noticed that some have a tendency to put WITH (NOLOCK) on every table in a SELECT query. When I inquire about this, the typical response I get is usually along the lines of “It keeps locks from happening so my query runs faster.”  Well…that’s not exactly what NOLOCK is for. Always putting WITH (NOLOCK) on every table in your SELECT query is a really bad practice.  To quote the great DBA sage Inigo…

Read More...

Useful Tools: sp_whoisactive

One incredibly useful SQL Server tool that I often forget about is Adam Machanic’s sp_whoisactive procedure.  The reason I…

Read More...

SQL Server Maintenance Scripts

When it comes to everyday routine maintenance of your SQL Server databases, you can’t beat Ola Hallengren’s SQL…

Read More...