SQL Soundings

I'm not going to try to convince you in English not to use BETWEEN with dates. Run the code below to see why it's not a good idea. (...

If you're using OPENQUERY and get this error: OLE DB provider "SQLNCLI10" for linked server "MYREMOTESERVER" returne...

This script will find all the databases (matching a certain pattern) on the server where a given user is not a member of a given role. Beca...

This script will load all the trace (*.TRC) files in a given folder into a single trace table. You have to specify the database to create th...

Sometimes you run across a server that for one reason or another is full of MDF, NDF, and LDF files that look to be months or years old. Of ...