SQL Sever Management Studio (SSMS)

Why am I unable to save changes after editing table design in SSMS?

Nov 25, 2020 by Beaulin Twinkle

Unable To Save Changes After Editing A Table Design In SSMS

Solution for unable to save changes after editing table in design window of SQL Server Management Studio.

Formatting SQL statements in SSMS

Dec 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.