I am very pleased to write my 500th post on SQLAuthority. Thank you to my family and to all of you, plus a look at the blog’s milestones so far.
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.
SQL SERVER – 2005 – A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold
The BOL script to defragment all indexes in a database above a declared threshold failed with Msg 2501. I fixed the missing schema prefix so it runs on SQL Server 2005.
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.