SentryOne Team Blog (blogs.sentryone.com)

Category : SQL Server

Latest Builds of SQL Server 2016

Latest Builds of SQL Server 2016

See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.

Erin Stellato : Examining the Performance Impact of an Adhoc Workload

Erin Stellato : Examining the Performance Impact of an Adhoc Workload

Erin Stellato discusses the performance impact of a predominately adhoc workload in SQL Server.

Paul White : Minimal Logging with INSERT…SELECT into Empty Clustered Tables

Paul White : Minimal Logging with INSERT…SELECT into Empty Clustered Tables

Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into an empty clustered table.

Latest Builds of SQL Server 2017

Latest Builds of SQL Server 2017

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.

Itzik Ben-Gan : T-SQL bugs, pitfalls, and best practices – subqueries

Itzik Ben-Gan : T-SQL bugs, pitfalls, and best practices – subqueries

Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.

Paul Randal : Introduction to Wait Statistics

Paul Randal : Introduction to Wait Statistics

Paul Randal provides a detailed introduction to troubleshooting SQL Server workload performance using wait statistics.

Paul White : Minimal Logging with INSERT…SELECT into Heap Tables

Paul White : Minimal Logging with INSERT…SELECT into Heap Tables

Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into a table without a clustered index.

Azure SQL Data Warehouse Delivers a Win-Win on Price-Performance

Azure SQL Data Warehouse Delivers a Win-Win on Price-Performance

Most organizations are familiar with the constant exercise of prioritizing price or performance, particularly in decisions about technology infrastructure. We know how tempting it can be to simply throw more hardware or compute power at a database performance problem. But even that short-sighted approach doesn’t work when budget is a concern.

Latest Builds of Management Studio

Latest Builds of Management Studio

Find information about the builds of SQL Server Management Studio in the new release cycle approach; locate previous versions.

Paul White : Grouped Aggregate Pushdown

Paul White : Grouped Aggregate Pushdown

Paul White goes deep on grouped aggregation pushdown, and explains examples where this optimization is unsuccessful or simply not attempted, using the undocumented command DBCC CSINDEX.

Latest Builds of SQL Server 2014

Latest Builds of SQL Server 2014

SQL Server 2014 is now at Service Pack 3, with plenty of enhancements back-ported from recent SQL Server 2016, 2017, and 2019 updates.

Sharing two T-SQL slide decks from CodeStock

Sharing two T-SQL slide decks from CodeStock

Aaron Bertrand shares his slide decks and demos from two recent presentations at CodeStock in Knoxville, TN.

Itzik Ben-Gan : Row Pattern Recognition in SQL

Itzik Ben-Gan : Row Pattern Recognition in SQL

Itzik Ben-Gan asks you to invest in SQL Server's future by voting for Row Pattern Recognition, a potential T-SQL syntax extension he deems the next step in the evolution of window functions.

Paul White : IGNORE_DUP_KEY slower on clustered indexes

Paul White : IGNORE_DUP_KEY slower on clustered indexes

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.

Filtered Indexes and INCLUDEd Columns

Filtered Indexes and INCLUDEd Columns

Rob Farley talks about filtered indexes and when you might want to add filtered columns to the index definition.