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

Guest Columnist: Gail Shaw

SQLServerCentral.com profile

   Items 1 to 17 of 17   
 

But, but, but, my data is clean!

Gail Shaw on the challenges of trying to extract meaningful data from a database containing customers who have the name 'Dummy **DO NOT USE**''.  Read more...
By Gail Shaw 2014/06/23 | Source: SQLServerCentral.com | Category: data degredation
Rating: (not yet rated) |  Discuss |   Briefcase | 182 reads

It's not you; it's us

The announcement that the MCM program was being discontinued brings us a few thoughts from Gail Shaw, one of the 0.08% to achieve the certification.  Read more...
By Gail Shaw 2013/09/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 458 reads

Stairway to Transaction Log Management in SQL Server Level, 8: Optimizing Log Throughput

This level takes a deeper look at how log fragmentation can affect the performance of operations that need to read the log, such as log backups, or the crash recovery process.  Read more...
By Gail Shaw, Tony Davis 2013/04/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,129 reads

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.  Read more...
By Gail Shaw, Tony Davis 2012/11/12 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 2,891 reads

Stairway to Transaction Log Management in SQL Server, Level 7: Dealing with Excessive Log Growth

This level will examine the most common problems and forms of mismanagement that lead to excessive growth of the transaction log.  Read more...
By Gail Shaw, Tony Davis 2012/11/26 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,662 reads

Stairway to Transaction Log Management in SQL Server, Level 6: Managing the Log in BULK_LOGGED Recovery Model

A DBA may consider switching a database to the BULK_LOGGED recovery model in the short term during, for example, bulk load operations. When a database is operating in the BULK_LOGGED model these, and a few other operations such as index rebuilds, can be minimally logged and will therefore use much less space in the log  Read more...
By Gail Shaw, Tony Davis 2012/11/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,043 reads

An examination of bulk-logged recovery model

This article looks at the bulk-logged recovery model in depth and examines how it affects disaster recovery and logging.  Read more...
By Gail Shaw 2012/05/07 | Source: SQLServerCentral.com | Category: recovery model
Rating: |  Discuss |   Briefcase | 4,787 reads

Recovery Models

Learn the basics of recovery models in this short article from SQL Server guru and MVP, Gail Shaw.  Read more...
By Gail Shaw 2011/09/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,211 reads

SQLSkills Immersion training in London

A wrap up from MVP and expert Gail Shaw on her experiences of training with SQLskills.  Read more...
By Gail Shaw 2011/07/27 | Source: SQLServerCentral.com | Category: training
Rating: |  Discuss |   Briefcase | 748 reads

Why is my transaction log full?

Why does the transaction log fill up? There are a variety of reasons, and MVP Gail Shaw walks you through the various things to check.  Read more...
By Gail Shaw 2012/08/31 (first published: 2011/02/21) | Source: SQLServerCentral.com | Category: transaction logs
Rating: |  Discuss |   Briefcase | 43,580 reads

Introduction to Indexes: Part 3 – The nonclustered index

Part 3 of a great series on the basics of indexes. Learn the structure, definition, and how to examine the use of these indexes in your queries.  Read more...
By Gail Shaw 2012/07/23 (first published: 2009/11/18) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 47,522 reads

Introduction to Indexes: Part 2 – The clustered index

In the second part of her series on indexing, MVP Gail Shaw examines clustered indexes. Learn what this index is, how it differs from a heap, and how it can help your queries.  Read more...
By Gail Shaw 2012/07/06 (first published: 2009/11/11) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 55,332 reads

Introduction to Indexes

Indexes are critical to good performance. However many people don't understand how indexes well. MVP Gail Shaw provides us with an introductory article on the basics of indexing.  Read more...
By Gail Shaw 2012/06/29 (first published: 2009/10/26) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 88,878 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 2014/01/17 (first published: 2009/06/12) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 44,678 reads

Help, my database is corrupt. Now what?

The stuff of nightmares, a corrupt database. However Gail Shaw gives you some advice about how to handle this situation.  Read more...
By Gail Shaw 2010/04/23 (first published: 2009/02/16) | Source: SQLServerCentral.com | Category: corruption
Rating: |  Discuss |   Briefcase | 38,263 reads

Managing Transaction Logs

A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.  Read more...
By Gail Shaw 2012/01/03 (first published: 2008/10/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 54,564 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 | 6,727 reads
   Items 1 to 17 of 17