Trying to script statistics in SSMS but the option is always disabled, even outside read-only databases? Here is why it happens.
SQL SERVER – Statistics for Read-Only Database are in TempDB
Statistics usually live in the same database as the table, so where do they go for a read-only database? The answer is TempDB. Here is how it works.
SQL SERVER – Building Three-Part Name from OBJECT-ID – Database Name, Schema Name, TableName
Have only an object_id? Here is a script to build the three-part name, database, schema and table, using DB_NAME, OBJECT_SCHEMA_NAME and QUOTENAME.
SQL SERVER – MySQL – Order Column by Nearest Value for Any Integer
How do you order column values by how close they are to any integer, such as -5? Here is a script that works the same way on SQL Server and MySQL.
SQL SERVER – SQL Server Configuration Checking – A Must Do for Every DBA – Notes from the Field #004
Still running on default settings? Mike Walsh explains why configuration checking is a must do for every DBA and how to fit SQL Server to your business.
SQL SERVER – Export Data AS CSV from Database Using SQLCMD
We often import CSV into SQL Server, but how do you export data as CSV with SQLCMD? Two simple commands, one with column headers and one without.
Elevator Etiquette: Small Rules for a Very Small Room
Elevator etiquette comes down to a few small habits: let people off first, give others room, keep the talk light and stay calm when you miss a door. Here are the rules I follow on conference trips, in office towers and on the way to an interview.