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.

Share Latest Blog Post


Recent From the Blog

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 say I forget about it is that it is not something that I use every day, it’s one of those tools that sits quietly in the background waiting until you need it.  But believe me, when the time comes that you need it, YOU NEED IT!  It gives you a way to see what queries and stored procedures are currently running,…

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...