This could start a flame war! I've seen instances of otherwise-seasoned coders on here using the dreaded

;WITH CTE...

.Please no >_< .Leading commas I accept as a preference, but leading semicolons are another matter entirely, lol .Those are like...

.Please no >_< .Leading commas I accept as a preference, but leading semicolons are another matter entirely, lol .Those are like...

Heh... if I were really smart, I'd just up and retire.  That would probably kill...

Don't get me started in WITH (NOLOCK). Apparently there are a number of people suddenly making that recommendation to get rid of blocking.

It's apparently easier advice to give people...

FFS

What a pain in the bottom.

I did agree with Jeff though. The answers on that other forum stunk.

To my knowledge, primary key or not, temp tables are cleaned up at the end of a connection. I'm not aware of circumstances that prevent this. Of course, a global...

Predicting the future is something I'm pretty bad at. Could something completely eliminate the need for a role that resembles that of the database administrator? Sure. What does that look...

First up, the only sure way to 100% validate a backup is good is to run a restore. The saying goes "You're only as good as your last restore." So,...

Apologies for being blunt, but that is simply not true.

Can...

Thanks everyone for the explanation.But one thing bothering me,

Considering the below example, I am in read committed isolation level and assuming that my table has 100 rows inside it.

now,...

I had close to twenty years experience when I started working with Azure back in 2008/2009. My organization wasn't using it. I just started learning it on my own. When...

There really isn't a direct mechanism from extended events to capture tempdb use by a given query, procedure or function.

While you could do what you've already done through the DMVs,...

When an INSERT occurs, a lot of locks are taken out. It's not just a question of adding a row at the end of the last page (assuming a clustered...

So that requires that you have distinct logins, OR, that everyone logs in and uses the application value on the connection string. Then, you can filter based on the login,...