SQL Server Trace Events

I answered a forum post the other day over on SSC on the differences between  the trace events stmtcompleted and...

SQL Server Useful Reading

I have been having an IO subsystem issue recently and I found the whitepapers very useful and wanted to post...

SQL Server Storage

This is a short post on SQL Server storage best practice and what i have learned over the years… Much...

SQL Server Waits and Queues

Useful link. This is a great best practice article/white paper from Tom Davidson and Danny Tambs.
 
 
The word document (880kb) can...

SQL Server Default Trace

The default trace in SQL Server is something I have been experimenting with lately. It is a feature included in...

“Building a Better Blog” with Steve Jones

I recently watched  Steve Jones’ (Blog | Twitter) "Building a better blog" presentation from the 24 hours of PASS virtual conference...

Professional Association of SQL Server (PASS)

I recently discovered the Professional Association of SQL Server (PASS) virtual chapters. For those of you who struggle to make...

SEO my SQL Server Blog

I was going to spend today finishing off some SQL Server related blog posts, I currently have a list of...

Wildcards in WHERE Clauses

This is just a very short post regarding the use of wildcards in a WHERE Clause

It is possible that the...

XML Index - ALTER INDEX with REBUILD Issue

I run into a small issue at the end last week, a CHECKDB job was reporting corruption on one of...