MS-SQL Server - GoFrag 'Resume Performance'

GoFrag 'Resume Performance'

 

GoFrag or Go for Fragmentation anytime during business hours as its not an application stopper.

We can Defrag the fragmented indexes one by one.

The script to fetch fragmentation detail will be shared as per email request.

Below is the query syntax for Reorg

Alter Index [NC_Index_Name] on [dbo].[Table_Name] REORGANIZE;

Additionally,

Rows or Range clause

https://learn.microsoft.com/en-us/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-ver16

Restore VERIFYONLY and HEADERONLY

https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-statements-verifyonly-transact-sql?view=sql-server-ver16

Note:- The SQL Server is an Object/Table Oriented Relational Database Management System

Stored Procedure for sending mail.

EXEC msdb.dbo.sp_send_dbmail

    @profile_name = 'Your_Email_Profile'

   ,@recipients = 'recipient@gmail.com'

   ,@subject = 'Email from SQL DBA Support'

   ,@body = 'A Test mail'

GO

Sp_rename

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-rename-transact-sql?view=sql-server-ver16

Sp_help

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-help-transact-sql?view=sql-server-ver16

Varbinary String 

https://learn.microsoft.com/en-us/sql/t-sql/data-types/binary-and-varbinary-transact-sql?view=sql-server-ver16

Best Regards

T. Amit Vaid S.

amitvaid81@gmail.com