I think it's multiple people. The linguistic/competence switch didn't happen as a single event. At the time, there were clueless threads interspaced with ones showing competance, carried on that way...

There's a stray newline at the end of the link. Copy and paste, or click on the link and edit it in the address bar.

Yes, you'll need all of them

Syntax is nothing fancy. A RESTORE DATABASE with the norecovery option, a bunch of RESTORE LOG with the NORECOVERY and STOPAT options (where stop at...

If your developers are unwilling to do their job (developing correct, working code), then suggest to your boss that he consider getting someone in who can fix these kinds of...

Restore the full backup as a new database, restore the transaction log backups until just before the data was deleted. Bring the DB online. Copy the deleted rows over to...

Tbh, it's a stupid question which tells nothing about a candidate's ability to do the job (unless they are being hired to develop a Trivial Pursuit game)

Isolation level settings are session-specific. It only applies to the session from which you're running that query, not the whole server.

You got an answer to that on your other thread.

Latches aren't related to or affected by isolation levels. The latch in question is used...

Please post the query, table definitions, index definitions and the actual execution plan. Without those it's near-impossible to offer any useful advice.

No.

The first log you need is the first one which started after the data-copying portion of the full backup completes. That's usually very close to the end of the backup....

There are plenty of changes between the versions, new stuff,...

Honestly, I'd just go back to that person and explain to them how SQL's memory works and why looking at the page file is pretty much a waste of time...

Could you please post the CREATE TABLE statements for each of the listed tables, as well as same sample data in the form of INSERT statements, so that we can...