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.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
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 Script to Remove Data from Two Joined Tables||1||19|
|SSRS Deployment problem||5||64|
|Dynamic SQL select query||4||36|
|Requesting help with creating an SQL query to select similar records||4||12|