Answer Interview Question of the Week #034 with runnable DISTINCT and GROUP BY examples, grouped totals, NULL rules, and a COUNT follow-up.
SQL SERVER – Remove All Characters From a String Using T-SQL
A follow up on how to remove all characters from a string, now handling special characters too. The trick: keep only ASCII 48 to 57 and join the digits.
SQL SERVER – Different Methods to Extract Scale Part From Decimal Number
Need only the digits after the decimal point? Here are different methods to extract scale part from decimal numbers, using ABS with CAST or string functions.
SQL SERVER – Are Power Options Slowing You Down? – Notes from the Field #095
John Sterrett explains how Windows power options, like the default balanced power plan, can slow SQL Server down. Notes from the Field #095.
SQL SERVER – Script: Finding queries without JOIN Predicates
During a code review I spotted a query missing its join condition. Here is a script for finding queries without JOIN predicates in SQL Server.
SQL SERVER – Database Mirroring login attempt failed – Connection handshake failed
While building an AlwaysOn demo I hit the Database Mirroring login attempt failed error with a connection handshake failure. Here is how I fixed it.
SQL SERVER – Fix @@ServerName Property Value When Incorrect
A colleague’s @@ServerName returned NULL instead of the server name. Here is why the value can be wrong and how to fix the @@ServerName property.