SQL Performance Archives - SQLPerformance.com

The Sort that Spills to Level 15,000

Posted by Paul White on September 27, 2016 No Responses »

Sep 272016

Paul White shows that SQL Server sometimes produces very misleading information about the impact of sort operations.

Memory/Storage Technology Hierarchy and SQL Server

Posted by Glenn Berry on September 21, 2016 1 Response »

Sep 212016

Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers.

Plan Explorer 3.0 Webinar – Samples and Q & A

Posted by Aaron Bertrand on September 15, 2016 No Responses »

Sep 152016

Aaron Bertrand (@AaronBertrand) follows up a recent webinar on SQL Sentry Plan Explorer 3.0 with answers to about two dozen audience questions.

Expanding the uses of DBCC CLONEDATABASE

Posted by Erin Stellato on August 29, 2016 6 Responses »

Aug 292016

Erin Stellato (@erinstellato) goes into detail about some practical use cases for a new DBCC command in SQL Server 2014 SP2 : DBCC CLONEDATABASE.

Minimizing impact of widening an IDENTITY column – part 4

Posted by Aaron Bertrand on August 4, 2016 3 Responses »

Aug 042016

Aaron Bertrand (@AaronBertrand) continues his series on widening an IDENTITY column, showing how he would attack the problem directly.

Stretch Database in SQL Server 2016 RTM

Posted by Tim Radney on June 23, 2016 5 Responses »

Jun 232016

Tim Radney (@tradney) of SQLskills shows us how the Stretch Database feature has evolved from its early CTP beginnings to the RTM version released earlier this month.

Number of Rows Read / Actual Rows Read warnings in Plan Explorer

Posted by Rob Farley on June 2, 2016 4 Responses »

Jun 022016

Rob Farley (@rob_farley) looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.

1 2 3 … 25 26