Very nice question. I hadn't had the chance to use this function yet and the question code was a quick way to play with it and add it to...

And the argument for SARGable is once again reinforced. We can keep preaching to the choir and then fixing the slow performing queries to the unconverted. 😎

To keep...

if a field is a 6 character number, you’d need 8 bytes to store this numeric field as a string using VARCHAR(6) data type (one byte for each character plus...

Taking out the name and parameters makes sense. Those are already in the code.

I don't agree with taking out the descriptive parts because stored procedures can and will be...

My solution deals with ETL process logging and SSIS. Because I'm an ETL person.

I created an audit table that included the package name, the instance ID, the start events...

Don't forget the description field. It's useful for putting more detail about objects as needed.

This is one of those 'touchy topics' that tend to send people all over the map.

There's good and bad developers and there's good and bad DBAs. There's no standard...

Made my guess, ran the code, got back NULL. Not an empty record set - NULL.

I wonder what kind of CV he's shopping to get jobs in the current Next Big Thing when his experience is all over the board.

We got hit by ISNUMERIC early. It will convert text that happens to be valid hexadecimal into a positive hit. So we went to PATINDEX to find values...

This seems to take on two separate issues - control of their local computer and access control. As such I'll give my thoughts in that format.

Local Computer - I...

I'm not sure how you define "why something changed". That sounds more like a business rule.

Been there and had to make these decisions.

The short version is that we did a hybrid model.

Projects were split out by source. Daily lookup tables would all be part...

IMO you're a client consuming the data....

The DBAs keep my database servers running and happy. In return I keep them informed of things that may impact (or may not) the database servers.

Going to have a...