Browsed by
Tag: dba

SQL Server transaction log and the need for roll backs and roll forwards

SQL Server transaction log and the need for roll backs and roll forwards

A few days ago Kendra Little did a great Podcast about Write Ahead Logging in SQL Server. Key point is that all transactions are written to the transaction log first and then to the data file. This enables SQL server to fulfil the Durability requirement (one of the ACID properties of transactions). Kendra did a good job of explaining but I didn’t get her right the first time and did some research myself on roll backs and roll forwards. The…

Read More Read More

Dirty DBA Tricks: Convince SQL Server Cluster < 2012 to use local SSD for tempdb

Dirty DBA Tricks: Convince SQL Server Cluster < 2012 to use local SSD for tempdb

As the title suggests this blog post is about a neat trick, which a decent DBA typically wouldn’t consider if he/she had other options. It worked for me and it was a well thought option to go for. I am not very proud of this trick (therefore “dirty”) however it saved my day and perhaps it’s a valid option for you to go as well. Remember that you use SQL server in a non-supported way doing this and don’t blame…

Read More Read More