Parikshit Savjani, Author at SQLServerGeeks

SQL Server 2012 Indirect Checkpoints – Slide Deck

March 24, 2012September 18, 2014 - by Parikshit Savjani - 4 Comments.

Hi All, Recently SQLServerGeeks.com organized SQL Server Day event in Bangalore on 17th March, 2012. It was so overhelming for me and Amit Bansal to see around 130+ people turning up …

SQL Server: Unable to shrink the tlog file?

March 10, 2012August 28, 2014 - by Parikshit Savjani - 8 Comments.

This is the most common question I come across from some of the inexperienced DBAs in SQL Server or experienced Oracle DBAs who are administering SQL Server under the assumption that …

SQL Server: Does Parallel Plan for rebuild index impact the fragmentation of index?

January 16, 2012August 28, 2014 - by Parikshit Savjani - 7 Comments.

The title for this post might sound ironical since rebuild of the index is used to remove the fragmentation of the index so how does rebuild of index affect the fragmentation …