A service from Red Gate
Home SQL .NET SysAdmin Opinion Blogs Forums Books
Sign in  | Join  | Help
Authors  >  Grant Fritchey

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.
Controlling Execution Plans with Hints
by Grant Fritchey | 12 November 2009 |  6 comments |
The Query Optimizer gets it right most of the time, but occasionally it chooses a plan that isn't the best possible. You can give the Query Optimiser a better idea by using Table, Join and Query hints. These come with a risk: Any choices you force on the Optimizer... Read more...
SQL Server Execution Plans - eBook Download
by Grant Fritchey | 07 October 2009 |  6 comments |
Why is my query running slow? Why isn't my index getting used? In order to answer these questions, you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed guide to this... Read more...
Understanding More Complex Query Plans
by Grant Fritchey | 26 February 2009 |  3 comments |
In order to be able to tackle performance issues in SQL Server , and write effective SQL, it is essential to gain a sound understanding of execution plans. Grant's previous article described graphical execution plans for Simple SQL queries. He now moves on to... Read more...
Graphical Execution Plans for Simple SQL Queries
by Grant Fritchey | 16 December 2008 |  10 comments |
Learning how to read and analyze execution plans takes time and effort. But once you gain some experience, you will find them an essential skill for getting to grips with performance issues in SQL Server Queries. Grant here describes the range of execution plans for... Read more...
SQL Server Execution Plans
by Grant Fritchey | 30 June 2008 |  1 comment |
Why is my query running slow? Why isn't my index getting used? In order to answer these questions, you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed guide to this... Read more...
Execution Plan Basics
by Grant Fritchey | 11 May 2008 |  33 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 |  28 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 |  86 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 |  13 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


Privacy policy | Terms and conditions | ©2005-2010 Red Gate Software
About | Site map | Become an author | Newsletters | Contact us