Auto growth should be a safety net, not a routine. Here is a script to find the growth size for all files in all databases and spot risky 10% settings.
SQL SERVER – Mistake to Avoid: Duplicate and Overlapping Indexes – Notes from the Field #073
Indexes do not always improve performance. Kathi Kellenberger explains why duplicate and overlapping indexes are a mistake to avoid.
SQL SERVER – Knowing Nested Transactions Behavior with SQL Server
Does SQL Server start a new transaction for every BEGIN TRAN inside another? I show nested transactions behavior with a simple demo for a reader.
SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location
When readers report a strange error, I first ask for the SQL Server ERRORLOG. Here are the various ways to find the ERRORLOG Location on your server.
SQL SERVER – Backup and Restore Behavior of ReadOnly Filegroup Databases
How do backups behave for a database with a ReadOnly filegroup, and does a restore keep that setting? I walk through it with simple T-SQL scripts.
SQL SERVER – Add Node in Cluster – Rule “Node and cluster edition match” failed
Running AddNode on the second cluster node failed with the rule Node and cluster edition match. Here is what the setup logs revealed and how to solve it.
SQL SERVER – Adding a Master Data Services to your Enterprise – Notes from the Field #072
Reeves Smith explains why you should add Master Data Services to your enterprise and why data governance is often overlooked in data warehouse projects.