Totally understood and agreed but, YOU asked! 😀 😀 😀

First, and to set the record straight, the...

1. Please provide the complete CREATE TABLE statement for the dbo.Member table.  This must include all constraints, keys, indexes, and FKs that may be pointed at the table for the...

Most people would tell you...

While I agree with that, the comparison that just came...

Probably the same thing as what has happened to humans (which I already have some good proof...

Fun fact:  Your article reveals an error in how SQL Server casts numeric to float.

STR(.922337203685477580,19,19)   should end in 776, but it ends with 777.

Further investigation shows that cast(.922337203685477580 to...

BTW... if you want a super early warning for something that has gone wrong with pages being used in a database, consider setting up a job that checks the suspect_pages...

Ok.. I've checked the code you provided for both the DBCC CHECKDB and the Backups.  There are some serious opportunities for improvement in both...

With regards to the code provided for...

And thank you for the kind feedback!

Sorry... duplicate post deleted.

Welcome aboard!

Rather than me explaining the things in the code that I demo, here are some references that do a better job than I could do.  Code specific to your...

Freakin' awesome test post, Jonathan.  Well done, good Sir!!!  This also proves something else... code written to do a specific task is highly likely to blow generic methods out of...

I need to split the column 'DiagnosisCodes' into 4 new columns 'Diagnosis1', 'Diagnosis2', 'Diagnosis3' and 'Diagnosis4' for the unique ChartProcedureId's. If they add more DiagnosisCodes, I only need the...

I think you can beat any splitting function by splitting in code with no need for aggregation.

As there are only a maximum of 4 values you can...