The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
DECLARE @kill as varchar(100), @body as varchar(5000), @AlertSummary as varchar(1200), @Timestamp as varchar(1200), @Instance as varchar(1200) set @kill = @kill + 'kill ' + SUBSTRING( $(AlertSummary) , 11, CHARINDEX(' ', $(AlertSummary) ,12) -11); set @body = cast(@kill as varchar(15)) + '; ' + 'A SQL process with '+ $(AlertSummary) + ' at ' + $(Timestamp) + ' on ' + $(Instance) + '. ' +' As the tempdb storage it used has reached a limit, this SQL query has been killed'; EXEC msdb.dbo.sp_send_dbmail @profile_name = 'noreply', @recipients = '<email>', @body = @body, @subject = 'Testing: A SQL query using too much tempdb database has been killed'
$(Timestamp), $(Metric) on $(Instance) is $(Severity). $(AlertText) $(Metric): $(Description)
|SQL date incremented||11||27|
|SQL Server - Set Value of Multiple Fields in One Query||10||22|
|Query to capture 5 and 9 digit zip code?||4||20|
|Need help constructing a conditional update query||16||42|