SQL Server Agent fails to start with Error 15281 because Agent XPs are turned off? Here is how to enable Agent XPs with sp_configure and start the agent.
SQL SERVER – CTE can be Updated
Users often confuse a CTE with a temp table, but a CTE works like a view, and a CTE can be updated just like one. Matthew Spieth’s tip, with my notes.
SQL SERVER – DMV to Identify Incremental Statistics – Performance improvements in SQL Server 2014 – Part 3
Part 3 of my series on SQL Server 2014 performance improvements: a DMV to identify incremental statistics, after the basics and a simple example.
SQL SERVER – Simple Example of Incremental Statistics – Performance improvements in SQL Server 2014 – Part 2
Part 2 of my series on SQL Server 2014 performance improvements: a simple example of incremental statistics, after learning what it is in part 1.
SQL SERVER – What is Incremental Statistics? – Performance improvements in SQL Server 2014 – Part 1
This is the first part of the series Incremental Statistics. Here is the index of the complete series. Let us learn it together in the blog.
When In-Memory OLTP Helps and When It Does Not
Learn when In-Memory OLTP can reduce transaction contention, which limitations still matter, and what to measure before changing tables.
What the Cardinality Estimator Does and When It Is Wrong
Understand how the cardinality estimator predicts rows, why estimates go wrong, and which statistics and plan checks help you investigate.