Everything Bill has said is 100% correct. I just want to reinforce it.

Proper normalization improves performance. You store smaller amounts of data. This means fewer reads and writes...

If you're going to do this, use sp_executesql and build out the query and WHERE clause using parameters. As was already mentioned, otherwise you are absolutely opening yourself to SQL...

So you 're getting page locks because the engine has determined that there will be too many rows to use row locking. Trying to improve performance by forcing the locking...

Another mechanism would be to capture logins using Extended Events. Also, you can capture calls against the database using Extended Events.

Reading back through this set of comments is interesting. It does seem to boil down to the belief, by those who have degrees in CS, that the only true path...

Just piling on.
It'll be faster if you use natively compiled. It won't be orders of magnitude faster, but it'll run faster. The question I have, if you have a...

The thing is, a backup file doesn't have to have any particular extension. You can run a command to backup to a .DOC file or .TXT or any other thing...

Disco?
But I survived the seventies. Why on earth would I want to go back?
Ah well, I'll start polishing my Hustle skills. I can probably remember the Bus Stop...