SQLandSai
Tuesday, 16 February 2021
Get Indexfragmentation details for all databases in a SQL Server instance
›
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED GO DECLARE @Tbl TABLE ( ServerName VARCHAR ( 128 ) , DBName VARCHAR ...
Monday, 21 September 2020
Script to send e-mail once transaction logfile usage reaches to 60%
›
USE msdb SET NOCOUNT ON ; IF OBJECT_ID ( 'tempdb..#MonitorTransactionLogFileUsage' ) IS NOT NULL DROP TABLE #Monito...
Script to monitor TransactionLogFileUsage and trigger backups automatically once logfile usage reaches to 40%
›
IF OBJECT_ID ( 'tempdb..#MonitorTransactionLogFileUsage' ) IS NOT NULL DROP TABLE #MonitorTransactionLogFileUsage CREA...
Thursday, 17 September 2020
Identify queries causing logfile growth or consuming CPU,Memory
›
During troubleshooting performance related issues such as what is caused for log file growth , currently running , causing CPU spikes etc t...
Friday, 4 September 2020
Fix : Msg 4928, Level 16, State 1, Line 9 Cannot alter column 'XXXXXX' because it is 'REPLICATED'
›
Msg 4928, Level 16, State 1, Line 9 Cannot alter column 'xxxxxxxxxx' because it is 'REPLICATED'. I got this error when ...
›
Home
View web version