TechNet Magazine: SQL Q&A

All TechNet Magazine Columns

• SQL Q&A: Checksum Problems, Choosing the Correct Recovery Model and More
  Paul S. Randal - August 2009
  Paul S. Randal answers your SQL questions: How can I tell when there’s a checksum problem without waiting until the monthly maintenance plan? Is it true that using a GUID as the clustered index key can lead to performance issues with indexes? How can I choose the correct recovery model? And more!

• SQL Q&A: Backup Compression, Client Redirection with Mirroring, and More
  Paul S. Randal - February 2009
  Should you enable Backup Compression? How can you avoid dropped application connections during a failover? Paul Randal answers these questions and more in the latest installment of SQL Q&A.

• SQL Q&A: Row-Overflow, Differential Backups, and More
  Paul S. Randal - December 2008
  Paul Randal answers your questions about SQL Server. In this installment, Paul discusses the row-overflow feature, database mirroring and automatic failovers, backup strategies, and managing workloads and memory for failover scenarios.

• SQL Q&A: Large Transaction Logs, When to Use Repair, and More
  Paul S. Randal - October 2008
  In this installment, Paul Randal answers questions about backing up and restoring, looks at the differences between log shipping and database mirroring, and explains why the Repair function should only be used as a last resort.

• SQL Q&A: Partitioning, Consistency Checks, and More
  Paul S. Randal - August 2008
  Paul Randal answers your SQL Server questions, showing you how to perform consistency checks and other maintenance on very large databases, how to handle an accidental upgrade, and more.

• SQL Q&A: I/O Errors, Database Mirroring, and More
  Paul S. Randal - June 2008
  Paul Randal answers your SQL Server questions, showing you how to create corruption in a test database, helping you avoid a shrink-grow-shrink-grow cycle, and explaining how you can determine how many databases you can mirror before performance starts to degrade.

• SQL Q&A: Grow Databases, Use IFilters, and Connect Remotely
  Edited by Matthew Graven - April 2008
  Find out how to grow databases programmatically, learn how to use IFilters, and explore firewall settings that support remote SQL Server connections.

• SQL Q&A: Non-Clustered Indexes and Retaining Permissions
  Saleem Hakani and Dan Carollo - February 2008

• SQL Q&A: Memory Configuration, Performance Profiling, Setting Your Fill Factor, and More
  Edited by Nancy Michell - December 2007

• SQL Q&A: Login Triggers, Data File Defrags, and More
  Edited by Nancy Michell - October 2007

• SQL Q&A: CPU Bottlenecks, Restoring and Moving Databases, and More
  Edited by Nancy Michell - September 2007

• SQL Q&A: Finding Locks, Large Queries, I/O Statistics, and More
  Edited by Nancy Michell - August 2007

• SQL Q&A: Inside Clustering, Mysterious Hangs, the SA Account, and More
  Edited by Nancy Michell - July 2007

• SQL Q&A: 64-Bit Installations, Allocating Cluster Memory, and More
  Edited by Nancy Michell - June 2007

• SQL Q&A: Best Practices Analyzer, Multi-Core Processors, and More
  Edited by Nancy Michell - May 2007

• SQL Q&A: Rebuilding Indexes, Disk Queue Length, and More
  Edited by Nancy Michell - April 2007

• SQL Q&A: Daylight Saving T ime, Server Memory, and More
  Edited by Nancy Michell - March 2007

• SQL Q&A: Database Size, Mirroring, Marked Transactions, and More
  Edited by Nancy Michell - February 2007

• SQL Q&A: Data Archiving, Linked Servers, Measuring Bandwidth, and More
  Edited by Nancy Michell - January 2007

• SQL Q&A: Preventing Reboots, Installing Multiple Updates, and More
  Edited by Nancy Michell - December 2006

• SQL Q&A: Temp Tables, 64-bit Processing, Mirroring, and More
  Edited By Nancy Michell - November 2006
  Your queries answered by Microsoft IT professionals.

• SQL Q&A: Running in RAM, Agent Jobs, and More
  Edited by Nancy Michell - October 2006

• SQL Q&A: Predicates, Stored Procedures, and More
  Edited by Nancy Michell - September 2006

• SQL Q&A: Clusters, Snapshots, Log Shipping, and More
  Edited by Nancy Michell - August 2006

• SQL Q&A: Monitoring DBAs, Replicating Sprocs, and More
  Nancy Michell - July 2006
  Your queries answered by Microsoft IT professionals.

• SQL Q&A: Server Tuning, Log Shipping, Mirroring, and More
  Nancy Michell - May • June 2006
  Your queries answered by Microsoft IT professionals.

• SQL Q&A: Runaway Log Files, SQL Server Instances, and More
  Edited by Nancy Michell - March • April 2006
  Your queries answered by Microsoft IT professionals.

• SQL Q&A: Clusters, Isolation, and More
  Nancy Michell - January • February 2006
  Your queries answered by Microsoft IT professionals.

• SQL Q&A: Monitoring Tools, Memory, and More
  Nancy Michell - November • December 2005
  Your queries answered by Microsoft IT professionals.

• SQL Q&A: Troubleshooting Connections, Using Variables, And More
  Edited by Nancy Michell - Spring 2005
  Your queries answered by Microsoft IT professionals.

• SQL Q&A: SQL Server Express, Encrypting Data, and More
  Edited by Nancy Michell - Winter 2005
  Your queries answered by Microsoft IT professionals.