Find which database uses the most CPU from cached query stats and plan attributes, then use Query Store for restart-safe history.
Pluralsight Author Summit 2013: A Truly Amazing Experience
The Pluralsight Author Summit in Salt Lake City was three days of learning and networking with authors who all love to share knowledge. Here is my recap of the sessions, the dinners, the management talks and the last day at a ski resort, with the photographs.
SELECT a Single Row in SQL Server: SQL in Sixty Seconds #046
To SELECT a single row for a quick look at a table, set up an SSMS query shortcut that runs SELECT TOP 1. The tests here show which row comes back, how an index or a heap changes it, what it costs on a 200,000 row table and when to add ORDER BY.
SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek
Does a function in WHERE clause really hurt performance? Using AdventureWorks and STATISTICS IO, I show what happens and how to turn a scan into a seek.
How to Add Column at Specific Position in SQL Server
To add column at specific position in SQL Server, you have three tested options, because ALTER TABLE always adds the column last. This post shows a SELECT list, a view for loads and reports, and a full table rebuild. It also explains what the rebuild costs.
BACPAC or Backup: When an Export Is the Wrong Tool
A BACPAC export has rows in it, but it is not a recovery backup. Here is a small demo that shows the difference.
Finding Procedures Created With the Wrong SET Options
Find procedures with wrong SET options in sys.sql_modules, understand error 1934, and recreate modules with ANSI_NULLS and QUOTED_IDENTIFIER ON.