Well, I'm cancelling my trip next week. Actually, it's already cancelled.

My wife and I decided that the risk of becoming carriers isn't worth it without a strong reason to go....

I'd expect more from people buying commercial applications.

Good points

I am loving these excellent comments.

I will point out that developers have a very short and predictable list of persistence requirements: load a grid, populate a form, save on...

When working with SP inside a .net project feels like Blackbox development. The Code you write looks like it assumes too much and needs a magic trust to what...

In today's cloud world vendor lock-in is an issue with most stored procedures being DB platform specific (MSSQL vs PLSQL vs MySQL).  Having to deploy an additional server just...

"...from a developer point of view..."  Why is it "more difficult" to build with stored procedures:

1. 1. It makes your entire project dependent on the DBA.  Not...

Security is getting better, attacks are getting more creative and complex.

Once we get rid of all these simple attacks, and many of them are simple and easily preventable, it will...

No word. I'll bump the message if I don't see something later today

Cache is by database, not by instance. You need to run this in each db. You can script that, but i'd include the name of your db in the result...

It's easy to do, but there are potential issues, as Dino pointed out.

You might read this: https://www.red-gate.com/simple-talk/sql/sql-development/beginner-guide-to-in-memory-optimized-tables-in-sql-server/

I don't think it's an issue, but I get your concern. I'll send a query to MS.

Closing. Please answer in the other post.

The only thing that appears to be missing from the procedure is the memberid. If this is only for one user, you can get that value from the membermaster table...

Like others, I tend to use paper/pen. I often will get this moved to some electronic medium, like Visio, but it's a manual thing. There are tools, but they tend...