I often times get the question similar to “Why is my log file not shrinking when I do regular backups”? It goes to show there the functionality of the SQL Server transaction log is not entirely clear. The way that …
Why is my log file not shrinking when I do regular backups? Read more »
I discovered this recording from a Database corruption repair presentation that I did a few years ago: Related Links Corruption Repair by Stedman Solutions Corruption Challenge
Here is a question that I received from a friend today and I thought it would be a good post explaining the details: Steve, I have a question on DBCC FREEPROCCACHE. I used sp_blitzcache from Brent and it shows that …
For a couple of months we have had requests on the SQL Data Partners Podcast to do an episode on indexing. It is my pleasure to announce that the Indexing episode was released today, well at lease half of it. …
Podcast Episode – The Long Awaited Index Episode Read more »
How often should I reboot SQL Server? It is a common belief with computers that rebooting cleans things up in memory and that they run better if they are rebooted more often. With your windows desktop or your cell phone …
Database Corruption Overview: Database corruption is one of those things that you can only plan for by practicing your response plan. Out of all of the things that can happen to your SQL Server this is the one that you …
Today on the tuning minute on the SQL Data Partners Podcast, we discussed duplicate indexes, which lead me to think more about and and write this post. You know there are many different ways of doing things in SQL Server, …
TL;DR summary: Don’t do it. Stop reading here if you want, but just don’t do it. This post refers to shrinking your database files (mdf, or ndf files), not shrinking the log file. The log file is a completely different …
DBCC ShrinkDatabase – I want to shrink my database. Read more »
I have been doing work with multiple clients using the GE Centricity EMR product which makes extensive use of Microsoft SQL Server. The performance issues that you run into with Centricity are very similar to what I see working with …
What 2015 meant to me and my business. Stedman Solutions, LLC – Startup After unexpectedly leaving a regular full time employment position on March 31st 2015, the very next day April 1st 2015, Stedman Solutions, LLC was launched. Looking back, …