Grant Fritchey Grant Fritchey
Grant is a database administrator for a major insurance company. He has 18 years experience in IT including time spent in support and development. He has been working with SQL Server since 6.0 back in 1995. he worked with Sybase for a few years. He has developed in VB, VB.Net, C# and Java. He is currently working on methods for incorporating Agile development techniques into database design and development at his company.
Execution Plan Basics
by Grant Fritchey | 11 May 2008 |  29 comments |
Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up again and again: Why is this query running slow? Is my index getting used? Why isn't my index getting used? Why does this query run faster than this... Read more...
SQL Server Performance Crib Sheet
by Grant Fritchey | 31 May 2007 |  18 comments |
Grant Fritchey provides an eagle-eye view of effective tools, strategies and techniques for SQL Server performance measurement, tuning and testing. Read more...
SQL Server Error Handling Workbench
by Grant Fritchey | 20 February 2007 |  25 comments |
Grant Fritchey steps into the workbench arena, with an example-fuelled examination of catching and gracefully handling errors in SQL 2000 and 2005, including worked examples of the new TRY..CATCH capabilities. Read more...
SQL Server 2005 Backups
by Grant Fritchey | 20 December 2006 |  83 comments |
If business today is data, then the entire enterprise is in the capable hands of you, the SQL Server DBA. Before you panic, check out Grant's detailed dissection of SQL 2005 backup and recovery regimes. Read more...
SQL Server Performance Testing
by Grant Fritchey | 15 May 2006 |  12 comments |
When faced with two viable solutions to a badly compromised database design, one using clustered indexes and the other compound primary keys, Grant Fritchey took the only sensible route: he gathered hard performance data... Read more...
Over 150,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk