Heh, I wouldn't say I am "smarter", I would say "I got lucky".  I took mrsiro's approach and just expanded on it.  A bad (or possibly good?) habit of mine...

I half agree with Jeff there.  Python may not be the best option for all use cases but, like cursors, there are cases where it is the best or only...

My opinion - I don't think there are that many use cases for using it.  Similar to R - you can access it externally, does it need to be baked...

Possibly not the most efficient approach, but I think this should work:

SELECT
[job3].[TheDate]
, REPLACE( [job3].[Security]
 , 'REMOVE:'
 , ''
 ) AS [Security]
, REPLACE( [job3].[Driver]
 , 'REMOVE:'
 , ''
...

Are you updating the tables sequentially or are some being done at the same time?

That being said, how many rows are being updated in tbl_people?  If on 2020-08-07 it updated...

• This reply was modified 5 years, 3 months ago by Mr. Brian Gale.

My opinion - I would use it when I need to do analytics on the data; similar to when you'd use R.

My approach though is to use these tools outside...

Alternately to Sue's approach, try matching your SSMS version to your SQL Server engine version.  I know some things behave strangely when you have mismatched versions.

It could be the disks.  It could be the data.  It could be the CPU or memory.  It could be blocking.  It could be none of those.  It could be...

I think this script will do it:

USE [msdb];
GO

SELECT
[name]
, [step_id]
, [step_name]
, [message]
, [run_status]
, [run_date]
, [run_time]
, [run_duration]
 FROM[dbo].[sysjobhistory]
 JOIN[dbo].[sysjobs]
 ON [sysjobs].[job_id] = [sysjobhistory].[job_id]
 WHERE[step_id] > 0;

Just add an extra...

My advice - check the dump.  Chances are it was not a specific query that caused the dump but something else.  Could be a driver issue, could be hardware failure,...

The issue is that NULL is an unknown value.  @x=NULL and NOT(@x=NULL) both give a result of FALSE.  Technically, they give NULL which gets evaluated to FALSE in a CASE...

You can read it from another location, but you may be missing the symbol libraries.  If possible, it is best to do it on the server that had the problem...

As a thought, it may not hurt to reach out to the creators of "Relativity" to see what they recommend.  Often the creators of the tool will have some good...

That is a fun one with NULLs.  The problem is that @x=@tempX can be true or false when either of those is NULL.  Doing a comparison on if @x=NULL or...

Pretty sure SQL has no built in way to monitor and alert for stack dumps.

This link has a powershell script for it though:

https://www.sqltechnet.com/2014/04/monitor-and-alert-sql-stack-dumps.html