Team Blog

Paul White explains why the IGNORE_DUP_KEY index option on a clustered index can result in much poorer performance than for a nonclustered unique index.
If you help your customers manage their data estate, you could be the one taking the brunt of their frustration when their data doesn’t provide the value they expect.
Rob Farley talks about filtered indexes and when you might want to add filtered columns to the index definition.
SentryOne partners, you can provide your customers with significant value, saving them time and money, by offering an easy way to fully document databases, including data lineage.
Find out the build number of each SQL Server 2017 build as it is released, discover where to download, and how to get details on new fixes and features.
See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.
A Historical Account of the Professional Association of SQL Server (PASS), Part 1: Foundation from Kevin Kline.
March 18, 2019 | Kevin Kline | SQLFamily, Community, PASS Summit, PASS 1
Tim Radney explains some of the nuances of performance tuning your workloads in Azure SQL Database and Azure SQL Database Managed Instance.

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial