Categories
General

SQL Server 2016 – Tempdb Configuration During Installation

After couple of years I’m started playing around the pre release packages. Today I installed Windows Server 2016 Technical preview release 3 and SQL Server 2016 CTP 2.4 in my machine to play around the upcoming release.

Categories
CSSUG General

April 2014 UG Meet

We are back in action 🙂 This time we will be conducting it after Tamil New year and before the election starts so that audience can enjoy their long leave or holidays.

Categories
General

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 explain you what’s recovery time and how does it matter in recovery situation.

Categories
General

sys.dm_db_stats_properties DMV

Service pack 1 for SQL Server 2012 has been released on 9th Nov 2012. It took couple of weeks for me to install it in our servers. Before I settle down I got another notification from Microsoft that Cumulative Update 1 has been released for SP1. So I started analyzing what they missed major in SP1 and finally I found a article by Aaron.

Categories
General

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.