SQLServerCentral - Guest Columnist: Gail Shaw

Introduction to Indexes

Indexes are critical to good performance in SQL Server. However many people don't understand how indexes work and why they are important. MVP Gail Shaw provides us with an introductory article to explain the basics of indexing. Read more...

By Gail Shaw 2009/10/26 | Source: SQLServerCentral.com | Category: Indexing

Rating:

|

Discuss |

Briefcase | 14,032 reads

How to Post Performance Problems

How do you get help? You can post a question on SQLServerCentral, but to get the most help you can, read this article from MVP Gail Shaw. Read more...

By Gail Shaw 2009/06/12 | Source: SQLServerCentral.com | Category: SQLServerCentral

Rating:

|

Discuss |

Briefcase | 7,005 reads

Help, my database is corrupt. Now what?

Managing Transaction Logs

A great article that should answer all your questions about the transaction log from MVP Gail Shaw. Read more...

By Gail Shaw 2008/10/31 | Source: SQLServerCentral.com

Rating:

|

Discuss |

Briefcase | 11,898 reads

Performance Implications of Database Snapshots

Books online mentions that performance may be reduced when using database snapshots. I decided to investigate how severe that reduction could be. Read more...

By Gail Shaw 2008/09/23 | Source: SQLServerCentral.com | Category: Performance Tuning

Rating:

|

Discuss |

Briefcase | 5,369 reads