Microsoft has recently released a single installer which now installs SSMS and ADS both together in a single Installation.
Find Outdated Statistics – SQL in Sixty Seconds #137
Is it possible that your statistics are many years old but still are valid? It is difficult to find Outdated Statistics is not as easy as it seems.
Oldest Statistics in SQL Server: Find the Stale Ones First
To find the oldest statistics in SQL Server, read the last update time and the number of changes since. This post builds a small demo, lists every statistic with its age and percent changed, and shows why a high change count on its own is not a reason to update by hand.
Arrow in Execution Plan – SQL in Sixty Seconds #136
Do you know what a single arrow means in an execution plan? While we popularly call it the arrow, there is a technical name for these little arrows.
Add Columns With NULL in SQL Server: ISNULL, COALESCE or SUM
To add columns with NULL in SQL Server, first decide what an empty value means. This post sums three nullable columns with the plus operator, ISNULL, COALESCE and SUM, shows where each one differs on a row of all NULLs, and compares their CPU cost on two million rows.
What is EDGE in SQL Server Execution Plan? – Interview Question of the Week #298
Question: What is EDGE in SQL Server Execution Plan?
Answer: It is the arrow or the line which goes from one operator to another operator.
5 Questions Answered OUTPUT Clause – SQL in Sixty Seconds #135
I have decided to create another SQL in Sixty Seconds video discussing the OUTPUT clause. In this video, we will discuss 5 questions.