CLR is the Common Language Runtime. A diagram of its architecture, and why CLR stored procedures in C# help with the loops and recursion that slow down T-SQL.
SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 2 – CTE
Part 2 of retrieving TOP and BOTTOM rows together: a reader’s solution using a CTE, the temporary result set introduced in SQL Server 2005.
Finding the Most Frequently Run Queries
Most frequently run queries can consume large SQL Server resources even when each call is fast; use plan cache and Query Store to find them.
SQL SERVER – Find Nth Highest Record from Database Table
The fourth Highest Record depends on whether ties occupy separate places. I define the ranking rule before choosing a query.
ACID Properties Shown With Real Transactions
ACID properties shown With Real Transactions uses short SQL Server scripts to explain atomicity, consistency, isolation, and durability.
CUBE: Include Every Two-Dimensional Subtotal Combination
CUBE requests every grouping combination of its dimensions, including independent subtotals and the grand total. I compare its output population with ROLLUP before choosing it. More subtotal families are useful only when the report needs them.
SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL
Need TOP 1 and BOTTOM 1 in one result? UNION fails with two ORDER BY clauses. Here is a simple T-SQL way to retrieve TOP and BOTTOM Rows together.