Latest from the Blog
Today, I want to discuss autogrowth in SQL Server. When creating a new database, SQL Server sets default values for autogrowth to handle sizing of the database files as they grow over time. As of SQL Server 2016, these defaults come from the values set in the model database. Unfortunately, these defaults are going to … Continue reading Configure Database Autogrowth
The latest T-SQL Tuesday invitation hosted by James McGillivray is all about breaks. I considered writing about how I manage breaks day to day but decided I’d rather reminisce and go back in time thinking about the best break/vacation I’ve had in the last few years. Check out the host T-SQL Tuesday post by following … Continue reading T-SQL Tuesday #134 – Taking a Break
Missing index recommendations are helpful but are not to be 100% trusted. Blindly creating every index that SQL recommends is a recipe for disaster. The recommendations are one tool to use in a belt full of tools. If you are testing indexes that are being recommended, it’s important to note the column order. I had … Continue reading Missing Index Recommendation Column Order
Get new content delivered directly to your inbox.