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.
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.
SQL SERVER – Simple Example of Cursor – Sample Cursor Part 2
A reader asked me to update my Simple Example of Cursor with AdventureWorks. Here is a sample cursor that loops through ProductID and prints each one.
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.
SQL SERVER – Transfer The Logins and The Passwords Between Instances of SQL Server 2005
How do you transfer the logins and passwords between instances of SQL Server 2005 after a hardware upgrade? I summarize Microsoft KB 918992 and its script.