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

On the importance of a complete break

If you’re the type who habitually checks work email and thinks about work while on holiday, here’s Gail Shaw's challenge for next time: don’t.  Read more...
By Gail Shaw 2014/09/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 111 reads

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 | 235 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 | 462 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,179 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,971 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,750 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,093 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,807 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,246 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,888 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,626 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,465 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 | 89,128 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 | 45,069 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,635 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,944 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,750 reads
   Items 1 to 18 of 18