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 7 of 7   
 

What SQL Statements Are Currently Using The Transaction Logs?

This article presents a utility that will show you what SQL statements are using the transaction logs, in terms of log space used and transaction duration.  Read more...
By Ian Stirk 2015/03/10 | Source: SQLServerCentral.com | Category: transaction logs
Rating: |  Discuss |   Briefcase | 10,163 reads

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,935 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 | 42,040 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,651 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 | 11,302 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 | 48,542 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 | 23,117 reads
   Items 1 to 7 of 7