No amount of memory is ever enough. Tim Radney explains the optimal memory settings for SQL Server, the setting people most often miss on a new server.
SQL SERVER – Finding Frequently Running Query and Elapsed Time – Notes from the Field #005
When the server is slow, first see what is running. Brian Kelley shows how to find a frequently running query and its elapsed time, two key facts for tuning.
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 – FIX : Error 3154: The backup set holds a backup of a database other than the existing database – SSMS
Error 3154 says the backup set holds a backup of a different database. Here is how to fix it in SSMS, plus the T-SQL RESTORE WITH REPLACE option.
SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field #003
Do not blame virtualization for slow servers. David Klee explains how many vCPUs are too many for SQL Server virtualization and how to set them up right.
A Server Trigger That Blocks Accidental Database Drops
A server trigger can turn a wrong-tab DROP DATABASE into an error message. Here is a small demo that guards one name and removes itself at the end.
SQL SERVER – Root Cause to Performance Problems – Notes from the Field #002
John Sterrett explains how to find the root cause to performance problems, so you fix what caused the issue instead of just turning off the alarm.