Excellent article - thanks!

Our company uses EF and stored procedures with error handling.  Our standard is to require Try/Catch blocks in all stored procedures. While I agree with Jeff Moden's point in principle...

• This reply was modified 3 years, 4 months ago by  Kazoo1989.

Excellent! Thank you.

Thanks for this.  Is the scope of this function the "Users" table only?  Is there a way to create global functions that can be applied across tables?

Great article - nice and concise as others have noted. 
We are using the Lag operator a lot in our work and find it not only improves performance, but readability...

Thanks for posting the article. It's important to look for ways to reduce comments down to only that content that is useful. I agree on removing the sproc...

I'm wondering the same thing. I did some looking around today but didn't find anything more than a couple of posts like this one. Anyone else?

As per the initial post we are using the audit tool provided with SQL Server 2008 (enterprise). We are unlikely to be able to use a 3rd party tool...