SHLIVA, Slab & Ultimate Pivot..
In terms of performance I am going to define SHLIVA today.
- Stored Procedure tuning
- History Cleanup (Maintenance, Agent Log)
- Logspace Shrinking
- Index Maintenance
- Virtual Log files
- Autogrowth & Autoupdate Statistics.
Slab based calculation
Ultimate Pivot
https://amit-sqldbasupport.blogspot.com/2022/11/sql-server-ultimate-pivot-script.html?m=1
Additionally,
Understand Blocking with Analyze Blocking Data
दर्पण (A Database Mirroring)
Lock Table for Insert
TABLOCK is shared Lock
TABLOCKX for exclusive lock
SQL Syntax
"INSERT INTO dbo.table_name WITH (TABLOCK)"
https://learn.microsoft.com/en-us/sql/t-sql/statements/insert-transact-sql?view=sql-server-ver16
Best Regards
T. Amit Vaid S.
No comments:
Post a Comment