SQL Server 2016 makes TempDB more scalable out of the box. Here are the enhancements with TempDB, from setup options to less contention under load.
SQL SERVER – Script: Remove Spaces in Column Name in All Tables
A reader wanted a script to remove spaces from every column name in all tables. Here it is, with a warning first: renaming columns can break your application.
SQL SERVER – How To Improve Performance by Offloading Backups to a Secondary Replica – Notes from the Field #108
Want more from two servers? In Notes from the Field #108, Eduardo explains how offloading backups to a Secondary Replica can make the primary server faster.
SQL SERVER – Unable to drop login – Msg 15170, Level 16, State 1
Cleaning up my demo server, I could not drop login danny because of Msg 15170: the login owns a job. Here is how to find what a login owns and remove it.
SQL SERVER 2016 – New T-SQL Functions – COMPRESS – DECOMPRESS
SQL Server 2016 adds two new string functions, COMPRESS – DECOMPRESS. Here is how they work, with examples, and the error you get on older versions.
SQL SERVER – How to Create a Readable Secondary Server in SQL Server Standard – Notes from the Field #107
A secondary server sitting idle as a backup feels like a waste. In Notes from the Field #107, Kenneth Urena shows how to make it readable in Standard Edition.
Interview Question of the Week #049 – Taking Database Offline
Taking database offline is one line of T-SQL with ROLLBACK IMMEDIATE. But what if your boss wants to wait 30 seconds first? Here is that script too.