You mean other than the one I linked in my first post...

I disagree MERGE is NOT atomic (it should be, it isn't) and hence both it and the IF...

I know, and I was looking forward to that session of Hugo's. 🙁

Maybe if you answered my question.

Not atomic, and...

Page IO Latch is a wait for the page to be read in to memory. Is it spending all the time waiting for that page, or are the waits across...

Anyone coming to InsideSQL tomorrow?

MikeS. (6/10/2016)

---

Trying to report off of tables that are constantly being backfilled with millions and millions of records of credit card information just doesn't work without the nolock, otherwise you'll...

Chitown (6/9/2016)

---

I just can't seem to educate users who runs this long query. Even though they pull unnecessary data, they just don't seem to understand. This is my last...

Then the first thing you need to do is review the immigration laws of that country you want to move to, what is required to get a work permit there,...

Why not educate the users so that they write good queries, rather than annoying them by killing their sessions?

I foresee failed backups and other maintenance tasks in your future, possibly heavier server load as reports are run again and again as they keep failing, and irate users. Possibly...

Could you be a little more specific?

No. There's the OS as well which uses memory. Plus whatever else is running on the server. If you've installed services you don't need like SSAS, those will be running...

You don't.