SQL Sever Management Studio (SSMS)

Formatting SQL statements in SSMS

Dec 13, 2019Dec 13, 2019 by Beaulin Twinkle

Formatting SQL statements or source code of procedures or function in SSMS is a daunting task. Here you will see how to use a plugin to format T-SQL in SSMS.

Reduce Index Fragmentation

Sep 13, 2018Aug 29, 2018 by Beaulin Twinkle

Here is the T-SQL queries to reduce index fragmentation by using either INDEX REORGANIZE or INDEX REBUILD. You will also see when to REORGANIZE and REBUILD.

Compatibility Level Field Is Disabled In SQL Server

Apr 17, 2018Apr 13, 2018 by Beaulin Twinkle

Unable to change SQL Server database compatibility level from management studio. Because the compatibility level field in the database properties window is disabled and grayed out.