I must avoid answering questions before breakfast - I didn't notice the boxes were squareinstead of round so only ticked what I would actually do - run sp_recycle_errorlog; restarting the...

I assumed that it wouldn't have changed between 2014 and 2016 so picked two files (a full back and a differential named --differential) because that's what I get in SQL...

This appears to me to be just plain wrong.

Since the first (serialized isolation level) query is using a lock which prevents updates and inserts, and a RANGES-S lock...

Although I got this right, I got it only by choosing the least wrong option.  The "right" answer is

On the grammar thing, I reckon most of the problems I see here are undetected typos, nothing to do with grammar.  Probably most people who post here can type pretty...

It's not actually as cut and dried as you suggest, frederico - certainly not in SQL Server 2012..
If the developer concerned has a CAL for the production system,  he...