From the article:

---

And most people rarely upgrade their OSS. They get something that works and don't want to change. I get that, as I feel the same way...

You can simplify the WHERE clause in AlphaNumericOnly and AlphaOnly by taking advantage of the fact that upper and lower case letters differ only by the 6th bit, which...

I'm a little late here but great observation, Anthony. I'll have to give that a try.

From the looks of things, MS hasn't done a good job on QA since 2017.

Does Example 7 of the following article do it for you?

https://www.mssqltips.com/sqlservertip/2999/different-ways-to-find-sql-server-object-dependencies/

Does example #7 in the article at the following link do it for you?  You can add criteria to only consider stored procedures.

https://www.mssqltips.com/sqlservertip/2999/different-ways-to-find-sql-server-object-dependencies/

Tru dat!

That other post can be found at the following link...

https://www.sqlservercentral.com/forums/topic/tracing-a-performance-issue

Removed accidental dupe post.

There's been some good things since 17 hit the streets.  They did, however, break copy'n'paste.  I have a special color (Red) that I use for ALL constants and a special...

It's also going to miss any and all "whole dates" (a.k.a. dates with a midnight time) for the 3 years involved.  The > should have been >= in all 3...

Ya just gotta...

I believe the more common, and better, naming for tables is plural.  I can't think of a major relational dbms that uses singular system table names.

For example: sys.objects (SQL...

Thank you all for getting back to me. I appreciate the advice. Because of your advice, I won't make a big deal out of removing the ID. Oddly, I...

That's the same reaction I had when the size charts gave me a hint about what was...