Tag Archives: T-SQL

Delaying Code Execution with Waitfor–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the rarely used commands for me is the WAITFOR command. This is a command that intentionally introduces … Continue reading

Posted in Blog | Tagged , , | Leave a comment

A Lack of Error Handling

I saw a post by Brent Ozar the other day, and it was a bit disturbing to me. A survey he posted on Twitter showed most people don’t bother with error handling in T-SQL. I’m not surprised, though I wonder … Continue reading

Posted in Editorial | Tagged | Leave a comment

Finding Failed Job Steps

Kendra’s query was a good starting point, and I used most of it in the first CTE shown below. This query basically looks at msdb.dbo.sysjobhistory and msdb.dbo.sysjobactivity, joining them on the job_id, which is the PK. However, we are only … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Better SQL is a Good Career Investment

Many of us reading this are data professionals, and we likely know quite a bit about SQL in general. We may use T-SQL, specifically, with SQL Server, but many of the skills we have would be portable to other dialects, … Continue reading

Posted in Editorial | Tagged , | 2 Comments