В свободном доступе появилась электронная книга - сборник мифов о Microsoft SQL Server - "Common SQL Server Myths", которая является компиляцией статей сайта SqlSkills.com.

Содержание:

• 1/30: In-Flight Transactions Continue After a Failover
• 2/30: DBCC CHECKDB Causes Blocking
  
• 3/30: Instant File Initialization Can Be Controlled From Within SQL Server.
  
• 4/30: DDL Triggers are INSTEAD OF Triggers 
  
• 5/30: AWE Must Be Enabled on 64-Bit Servers 
  
• 6/30: Three Null Bitmap Myths 
  
• 7/30: Multiple Mirrors and Log Shipping Load Delays 
  
• 8/30: Unicorns, Rainbows, and Online Index Operations 
  
• 9/30: Data File shrink Does Not Affect Performance 
  
• 10/30: Database Mirroring Detects Failures Immediately
  
• 11/30: Database Mirroring Failover is Instantaneous
  
• 12/30: Tempdb Should Always Have One Data File Per Processor Core 
  
• 13/30: You Cannot Run DMVs When in the 80 Compat Mode 
  
• 14/30: Clearing the Log Zeroes Out Log Records 
  
• 15/30: Checkpoint Only Writes Pages From Committed Transactions 
  
• 16/30: Corruptions and Repairs 
  
• 17/30: Page Checksums 
  
• 18/30: FILESTREAM Storage, Garbage Collection, and More
  
• 19/30: TRUNCATE TABLE is Non-Logged 
  
• 21/30: Corruption Can Be Fixed By Restarting SQL Server
  
• 22/30: Resource Governor allows I/O Governing
  
• 23/30: Lock Escalation
  
• 24/30: Twenty-Six Restore Myths
  
• 25/30: Fill Factor 
  
• 26/30: Nested Transactions Are Real
  
• 27/30: Use BACKUP WITH CHECKSUM to Replace DBCC CHECKDB
  
• 28/30: BULK_LOGGED Recovery Model
  
• 29/30: Fixing Heap Fragmentation
  
• 30/30: Backup Myths

Скачать книгу можно внизу статьи.