Resources


A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z


AlwaysOn Availability Groups
AlwaysOn Availability Groups and SQL Server Jobs
Making latest statistics available on Readable Secondary


Checkpoint
SQL 2016 – It Just Runs Faster: Indirect Checkpoint Default

CMem Thread
CMemThread and Debugging Them

Columnstore Index
List of blogs on columnstore index published by SQL Server Product Team

Corruption Recovery
Advanced corruption recovery techniques


DBCC CheckDB
A faster CHECKDB – Part I
A faster CHECKDB – Part II
A faster CHECKDB – Part III

Diag Manager
Troubleshoot like Microsoft Engineer


Extended Events
Converting SQL Trace to Extended Events in SQL Server 2012

ESXi Host
Gathering ESXi Host Information from VMware vCenter VCDB for Virtual SQL Servers


Health Check
Confessions of a Microsoft Addict


Index
Minion Reindex
Another Reason to Avoid sp_updatestats

I/O
How It Works: Bob Dorr’s SQL Server I/O Presentation
What is SQL Server’s IO Block Size?
Deploying SQL Server 2005 with SAN #1
Deploying SQL Server 2005 with SAN #3


Kerberos and SPN
SQL Server Kerberos and SPN Field Guide
Duplicate SPN: What is it really?


Performance Counters
Sys.dm_os_performance_counters Demystified
Interpreting the counter values from sys.dm_os_performance_counters

Performance Tuning
Slow in the Application, Fast in SSMS?
Understanding Performance Mysteries

PowerShell
PowerShell scripts that help enable SQL Server Migrations


Statistics
Query Tuning Fundamentals: Density, Predicates, Selectivity, and Cardinality
Limited Statistics Granularity
Inside the Statistics Histogram & Density Vector
SQL Server Tipping Games – Why Non-Clustered Indexes are just ignored!
Statistics Used by the Query Optimizer in Microsoft SQL Server 2008
Are My Statistics Correct?

SqlCmd
The SQLCMD workbench


Trace Flag
A Topical Collection of SQL Server Trace Flags

TCP Chimney
TCP Chimney Offloads and SQL Server Implementation

Test Data
Generate Test Data


Window Functions
Window Functions – Part I
Window Functions – Part II
Window Functions – Part III


XQuery
XQuery Labs – A Collection of XQuery Sample Scripts

FacebookTwitterGoogle+Share