Indirect Checkpoint – SQL Server 2012

I noticed an interesting feature that’s released with SQL Server 2012. In this version now you can set recovery time at database level. In other words now you can set when checkpoint should happen to a database which directly relates to the recovery time of the database. Before stepping into further I would like to… Continue reading Indirect Checkpoint – SQL Server 2012

FileStream FAQ

I have consolidated some frequently asked questions for FileTable. I’ll try to cover as much as I can so that all your questions related to Filetable can be clarified. All these answers are based on SQL Server 2012 version these may change in future version and editions which I’ll be updating with the latest release.