If you're using this function against multiple rows in a query, there's no way that I'd leave it as a scalar function.

Also, if you're only allowing for Windows logins by users and apps (and I do recommend that), you can use sp_ValidateLogins to find any logins on SQL Server that have...

My question would be... Do you actually need AG or would a Clustered Server be adequate?  I know too many people that are using AG just because "it's too cool...

We have a scalar function that is used to add a specific number of business days to a date however to dev who wrote it has gone overkill on...

Setup a "Login Trigger".  Be REALLY careful because, if you do it wrong", even you won't be able to login.

It's amazing what people will do.  Yep... Jonathan's method for tracking page splits is awesome.

But what are YOU going to do with the information?  Ah... use it to identify which...

No.  You don''t use "ALTER" ...

But, in this case, having the Clustered Index on the UserID is probably perfect.

You also won't need a non-clustered index on UserID then, either.

I agree there.  "It Depends".  Concatenation typically is quite slow but might be worth it here.  I have also run into performance issues with cCA's (Cascading Cross Apply's) before but...

My recommendation is ... TRY IT!  See what happens.  😉

Yep, there's not much you can do to speed it up.  However, you can be sure to shrink only the specific file(s) you need to shrink, not the entire...

I agree that...

"It Depends".  I've found that a whole lot of folks end up writing code that...

Apologies for not including more detail on the issue.  The error is"An INSERT EXEC statement cannot be nested."

I tried changing the table variable to a temp table but still...

It partially depends on WHY you have so much free space in your database.

If a lot of old data has been deleted and, like most people, end up doing just...