DECLARE @MaxThought INT;

SELECT @MaxThought = MAX(thoughtid) FROM TRP_thoughts;

SELECT * FROM TRP_thoughts WHERE thoughtid = FLOOR(RAND(CHECKSUM(NEWID()))*@MaxThought)+1;

Should get you a random row each time, and is more efficient than the usual TOP...

Considering that most people here probably aren't familiar with that practice exam, you may want to explain further what you're trying to do, what exactly is failing and what the...

Post the checkDB output. Got an older backup?

Or use a table-type parameter and use it in an IN subquery

WHERE ID IN (SELECT ID FROM @TableTypeParameter)

Run the following for each DB, post the full and complete results.

DBCC CheckDB(<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS, EXTENDED_LOGICAL_CHECKS, DATA_PURITY

And maybe change your job to include the NO_INFOMGSG option. The number...

The parameter -m starts SQL in single user mode, you can connect with any client tool.

They're not.

If you restart SQL in single user mode, then, while SQL is in...

Can you post the query and the 'bad' execution plan?

Neither. It's there to show readers that EXISTS...

Be honest. Don't exaggerate your experience. Don't claim familiarity with things that you're not familiar with.

No, it can't. You'd do that with a client timeout, though the timeout affects the entire batch sent to the server, not subprocedures.

Aaah...

I'm hunting for a thread from July this year (before 18th July) on an apparent missing exclusive lock and strange lock escalation behaviour. I posted extensively to it, I know...

Beside being appallingly bad advice (shrinking a log to 0 just forces SQL to spend a...

I don't know merge replication, you should have said in the initial post it was for merge replication, not snapshot replication.

I suspect the error means exactly what it says.

the version...

Yes, it's bad practice. SA is well known, and with the brute-forcing capabilities these days, 15 characters is not a strong password. It's known to be an admin account, it...