Instead of New Year’s resolutions, Tim Radney suggests looking back. Here are his Year 2014 reflections, a great way to plan the year ahead.
Refactoring Old T-SQL One Procedure at a Time
Begin refactoring old T-SQL with one procedure, repeatable inputs, duplicate-aware result checks, measured reads, and a simple change log.
Exporting and Sharing Registered Server Groups in SSMS
One shared server list can save you from running a query on the wrong server. Here is how to build it, export it without passwords and use it.
SQL SERVER – UNION and UNION ALL with TEXT DataType – Observation
UNION fails on a TEXT column with Msg 5335, yet UNION ALL with TEXT datatype works fine. Here is the code so you can try the difference yourself.
SQL SERVER – Puzzle – Why Divide by Zero Error
Why does SELECT 10000/(17/17/17) return a divide by zero error? A new puzzle, similar to my decimal rounding one but with a different approach.
CXSYNC_PORT and CXSYNC_CONSUMER Waits in Parallel Queries
Investigate CXSYNC_PORT with session wait deltas, parallel plan exchanges and thread rows before testing a query-level MAXDOP change.
The Last Entered Row: Why a Table Needs an Ordering Column
A table has no last row until you define one. Here is how identity, event time and ties give different answers.