With your ROUND, you are rounding to 3 decimal places so that is why you are getting a bunch of 0's.

So your options are:

1 - change your ROUND to be...

As a thought, are your SPN's set up correctly?

I know I hit that snag YEARS back and I found a SO article about that error message where they are reminded...

Might be a silly question but did you set up both the web portal and web service for SSL?

I would probably take this approach (although not that efficient, it is easy to read in my opinion):

where (p.JCCo=@Company and p.Job=@Job and substring(Phase,1,3) not in (' 00','...

I agree with Steve's view on this one.  I'd also like to add that SSL encryption is VERY fast and it only encrypts data in motion.  Websites using HTTPS is...

Did a quick google on this and found this link:

https://stackoverflow.com/questions/18996157/what-does-lock-communication-buffer-resources-mean

From what I am understanding from the above, the communication buffer in a deadlock means that there were multiple parallel processes...

• This reply was modified 4 years, 3 months ago by Mr. Brian Gale. Reason: added "edit" section

I agree with ZZartin and even have a sample script that replicates this behavior:

CREATE TABLE #tmpTable (id INT)
GO
SET STATISTICS IO ON
INSERT INTO [#tmpTable]
(
[id]
)
VALUES
(
0-- id - int
)
INSERT INTO...

• This reply was modified 4 years, 3 months ago by Mr. Brian Gale. Reason: fixing up some of the TSQL

There are a few things I'd check.

In no particular order:

I'd try to create a new job, run it, and see if it logs the job history.  It could be something...

ok, so step 1 from what I had was to get all of the job status's within the timeframe.  The query you have handles that, but I'd pull out some...

That approach works if you are storing it in a table.  Just add that as a column to the table.

It depends entirely on the approach you want to take and how you are planning on storing the data permanently.

Is this data going into a table or is it generated...

As for generating a checksum, this is entirely possible, but it depends on how you want to handle it and what you plan to do with it.

If I understand the...

First thing I'd be curious about is with the wait stats for PAGEIOLATCH_SH being over 2 million, is that for that one job OR since the instance started?

Quick google on...

Sorry, my query had a typo in it - I missed giving the quantifier for the part number in the CTE.

This one should work better:

DECLARE @MaskChar CHAR(1)...

It is definitely possible, but does become more challenging based on what you have in your original query.  What would probably be easier would be something more like this:

This reply was modified 4 years, 3 months ago by Mr. Brian Gale. Reason: Removed NOLOCK as I don't think that hint is actually required