Viewing 15 posts - 19,606 through 19,620 (of 22,202 total)
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...
September 9, 2008 at 6:42 am
Yeah, MAXDOP has been useful situationally. Although if I see a lot of queries suffering from parallelism, I'll raise the threshold.
September 9, 2008 at 6:07 am
lklein (9/8/2008)
September 8, 2008 at 8:00 am
lklein (9/5/2008)
September 8, 2008 at 7:34 am
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...
September 8, 2008 at 6:10 am
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...
September 8, 2008 at 5:59 am
We keep track of every object in the database within source control.
September 8, 2008 at 5:52 am
Neither. I prefer the granular control you get from writing your own backup methodology.
September 4, 2008 at 12:50 pm
Yeah, keep your hands and feet inside the vehicle at all times.
September 4, 2008 at 12:21 pm
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...
September 4, 2008 at 12:15 pm
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.
September 4, 2008 at 12:05 pm
Sure. Zip it up and attach it.
September 4, 2008 at 12:03 pm
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...
September 4, 2008 at 8:12 am
Oops. Serious egg on my face. That's new for 2008. It won't work with 2005. Sorry.
September 4, 2008 at 7:44 am
Viewing 15 posts - 19,606 through 19,620 (of 22,202 total)