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 – 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.
SQL SERVER – DBCC CHECKDB errors – Msg 2520 during executions
Running DBCC CHECKDB on ResourceDB returns Msg 2520. I explain why CHECKDB cannot run on the hidden resource database and what you can do instead.
SQL SERVER – Rewriting Database History – Notes from the Field #094
Kevin Hazzard tells the story of rewriting database history, a journey that starts and ends with ORM, in Notes from the Field #094.
SQL SERVER – Login failed for user . Reason: Token-based server access validation failed
Login failed for user. Reason: Token-based server access validation failed. Here is how the state of error 18456 in the ERRORLOG shows the cause and fix.