Guest Columnist: Ian Stirk

Ian Stirk has been working in IT as a developer, designer, and architect since 1987. He holds the following qualifications: M.Sc., MCSD.NET, MCDBA, and SCJP. He is a freelance consultant working with Microsoft technologies in London England. He can be contacted at Ian_Stirk@yahoo.com.

   Items 1 to 6 of 6   

 

A faster DBCC CHECKDB?

This article describes a utility that is able to report the most common DBCC CHECKDB errors significantly faster than DBCC CHECKDB does itself.   Read more...

By Ian Stirk 2011/08/23 | Source: SQLServerCentral.com | Category: dbcc checkdb

Rating: |  Discuss |   Briefcase | 13,418 reads

Targeted Index Performance Improvements

This article identifies which indexes are used when T-SQL code runs, and proposes ways of improving these targeted indexes, leading to better performing code.  Read more...

By Ian Stirk 2012/08/03 (first published: 2009/09/17) | Source: SQLServerCentral.com | Category: performance tuning

Rating: |  Discuss |   Briefcase | 41,808 reads

Get Performance Tips Directly From SQL Server

This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.  Read more...

By Ian Stirk 2012/06/22 (first published: 2009/06/11) | Source: SQLServerCentral.com | Category: performance tuning

Rating: |  Discuss |   Briefcase | 46,062 reads

Spring Clean Your Database Schema

The utility described in this article allows you to quickly identify which columns have mismatched data types across tables in a database. Correcting these will improve performance etc.  Read more...

By Ian Stirk 2009/01/19 | Source: SQLServerCentral.com | Category: administration

Rating: |  Discuss |   Briefcase | 10,703 reads

What SQL Statements Are Currently Executing?

This article describes a utility that allows you to identify what SQL statements are currently executing.  Read more...

By Ian Stirk 2009/12/11 (first published: 2008/10/28) | Source: SQLServerCentral.com | Category: dmv

Rating: |  Discuss |   Briefcase | 46,504 reads

Identifying Queries Running Slower Than Normal

The attached article describes a utility that allows you to quickly identify which queries are running slower than expected. Note this article was updated to correct the formatting issues.  Read more...

By Ian Stirk 2008/08/14 (first published: 2008/08/07) | Source: SQLServerCentral.com | Category: performance tuning

Rating: |  Discuss |   Briefcase | 22,899 reads

   Items 1 to 6 of 6