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.
Reduce Index Fragmentation
Tag: SQL Sever Management Studio (SSMS)
Compatibility Level Field Is Disabled In SQL Server
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.
Auto Generate INSERT Statements for a Table in SQL Server
Easy way to auto generate INSERT statements for a table in SQL Server using SSMS. Generate insert statements from sql server tables on the fly.
SQL Server Development And Management Tools
Top SQL Server Development And Management Tools. List of few popular tools which can be used for MS SQL Server development and management.
Installing SQL Server Management Studio (SSMS)
SSMS for SQL Server 2016 and higher. Installing SQL Server Management Studio Release 15 and higher for SQL Server 2008 or higher.