How do you setup Delayed Durability in SQL Server 2014? Here are three methods, starting at the database level with ALTER DATABASE SET DELAYED_DURABILITY.
SQL SERVER – Basics of Delayed Durability in SQL Server 2014
SQL Server 2014 adds Delayed Durability, which puts performance ahead of durability. I explain it in simple questions and answers, starting with full durability.
Stale Views: Why SELECT * Breaks After ALTER TABLE
Reproduce stale views after SELECT star and ALTER TABLE, find candidate definitions, refresh with sp_refreshview, and prevent the pattern.
SQL SERVER – The Basics of the SSIS Execute SQL Task – Notes from the Field #044
Many developers do not know SSIS can run SQL queries. Andy explains the basics of the SSIS Execute SQL Task in very simple words.
Live Execution Plan of a Running Query: SQL in Sixty Seconds #073
A live execution plan shows how far a query has gotten while it is still running. This post builds a slow query on SQL Server 2025, watches it through sys.dm_exec_query_profiles from a second window, and explains why rows divided by the estimate is a progress meter only when the estimate is right.
SQL SERVER – Live Plans for Long Running Queries
How do you see live plans for long running queries while they still run? SQL Server 2014 adds the DMV sys.dm_exec_query_profiles, and I show a simple test.
SQL SERVER – How to Know Cardinality of Executed Query?
Which estimator did SQL Server 2014 use? There are two ways to know the cardinality of executed query, starting with the execution plan properties.