Backup duration statistics

Here is a simple query which can list backup duration statistics for all database, including the max, min, avg of...

SQL Server – Cannot resolve collation conflict

A friend of mine contacted me through email today having a very common problem with a query he had written....

The Done Stamp

I’m fond of replying with “done” when a task is complete, no need for anything more elaborate. I’ve been experimenting...

Building a Presentation Map

This idea came up during a critique of a presentation. I may have re-invented (or re-labeled) something that is already...

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

MDS and Best Practice Analyzer new features were introduced in sql...

Recently Used Tables and Databases

Recently developed these queries to assist with the evaluation of development or sandbox environments.  Sometimes disk space demands that old...

It’s OK To Eat Alone

There’s a lot to be said for the philosophy of Never Eat Alone, using meals as a great time to...

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics

Earlier sql server was having diagnoses tool.

Default trace.

SQLDiag

And other tools but could not...

Always restore with NORECOVERY

Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option.
It’s trivial to switch the database online.
Not...

SSRS Performance in SharePoint Integrated Mode

I’m working with a client to help them move all reports in their company from native mode (Reporting Services not...