You can't just remove a lock. That's data being manipulated and stopping the manipulation mid-stream will break the integrity of the data in the table, possibly losing that data, the...

Yeah, MAXDOP has been useful situationally. Although if I see a lot of queries suffering from parallelism, I'll raise the threshold.

lklein (9/8/2008)

---

They were report starving. I just don't see how I can give them the data they want without using temp or declared tables. Any other ideas or...

lklein (9/5/2008)

---

It was just filling up. Then it got to big obviously and caused other issues. It had been 3 weeks since that server was restarted. Is...

The rotated 8 is a symbol for infinity. It means that you've defined a one-to-many relationship. That is, one person can have many clothes. But really, in a design of...

I remain where I was. Any of the hints can be useful in a given situation. My primary issue is when people see it as a general fix or best...

We keep track of every object in the database within source control.

Yeah, I've run into that one a few times too.

Neither. I prefer the granular control you get from writing your own backup methodology.

Yeah, keep your hands and feet inside the vehicle at all times.

From where I sit, NOLOCK is a crutch, not unlike DISTINCT, that can, in the short term, "fix" issues that are better approached by the hard slog of understanding how...

You can run multiple backups in parallel, but you'll want to monitor the system closely to be sure it doesn't badly impact performance.

Sure. Zip it up and attach it.

We go through the same worries about SANS all the time. You're completely dependent on your SAN admins to set up the drives appropriately and maintain them well. If your...

Oops. Serious egg on my face. That's new for 2008. It won't work with 2005. Sorry.