Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Ian Stirk

SQLServerCentral.com profile

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,678 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,937 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,330 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,919 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 | 47,451 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,977 reads
   Items 1 to 6 of 6