I wasn't trying to rag on you Steve.  I was just commenting on the different data types (at least in SQL 2008 R2 which I tested it in) that give...

While I agree with Jeff, it doesn't apply to all larger numbers.  TINYTINT, SMALLINT, and INT's have the same behavior but bigints throw an error instead.

As for the VARCHAR value,...

Can you post more information?

What I expect you are doing is something like:

SELECT *
FROM <TABLE>
WHERE <COLUMN> = 12.3

If that is the case, double check the datatype of...

Hi Jeff,

I sent you a PM on the scripts because I feel we are getting a bit off topic from the original post.  If you prefer, I can post it...

Still not seeing the "recursion" that is required here.  With the updated data, does this not work:

SELECT
[T1].[col11]
, [T1].[col1]
, [T1].[col2]
, [T2].[col5]
, [T2].[col6]
, [T3].[col9]
, [T3].[col2]
 FROMtable1 AS [T1]
 JOINtable2...

Looking at that data set and sample output, I am confused on a few things.  First, why would this need to be dynamic?  Second, why would this need to be...

thanks for the code Jeff.

Downloading it and looking through that today!

Hello Jeff,

Any update on that code?  I am curious to look at it.

Drew, I think that both single and double quotes are valid according to the XML standard (or at least my interpretation of it).

Microsoft's interpretation in the .NET framework allows for...

I believe your issue here is that code is not being provided a string literal which is required by the XML 1.0 standards.

Similar issue to yours, but slightly different:

https://stackoverflow.com/questions/13223781/xml-parsing-error-a-string-literal-was-expected-when-inserting-values-into-ta

His issue...

Hello Jeff,

Not sure if it is useful for the OP, but it does look like an interesting report to me.

I would like to have a copy of that if you...

Jeff - that script sounds useful.  Any chance you could post it on here or link to it on github or something?

Currently, we are using RedGate for our monitoring of...

Have a look at this webpage:

https://regex101.com/r/cO8lqs/2

It lets you test out RegEx and it provides an explanation of what the regex is doing.

Your understanding of that part is correct.  (.) is...

A failed ping also doesn't mean the server is "up".  Firewall, for example, could block a ping but the server could still be up.

That being said, if you want fewer...

Another thing to check is - is it actually SQL Server using the CPU?

If you have predictable times that the CPU is high, check things out in task manager as...