transaction log

7 Common SQL Server Transaction Log Myths

sql server transaction log myths

SQL Server is a complicated piece of software, so it’s understandable that some of us have some misconceptions about what the transaction log is and what it does. This post is designed to not just tell you about these myths, but also to show you a few ways how to prove (or rather disprove) some … Read more

5 common SQL Server Problems to Troubleshoot with sp_WhoIsActive

If there were a Mount Rushmore of SQL Server community tools, Adam Machanic would have to be one of the four faces. You may not know his name, but you more than likely know the free troubleshooting tool he created over a decade ago: sp_WhoIsActive. The beauty of WhoIsActive is in its simplicity. Install this … Read more