Viewing 15 posts - 8,641 through 8,655 (of 22,214 total)
If this is a one-time shrink after a major data clean up, it should be fine. You just want to avoid a situation where you're growing then shrinking the database...
March 18, 2014 at 4:08 am
Snapshot isolation is great when you have a mix of exclusive locks and shared locks because it isolates them from each other. But this is a mix of exclusive locks....
March 18, 2014 at 4:07 am
Blocked processes or resource contention on that one database. That's all it takes.
March 18, 2014 at 4:01 am
I'm pretty sure disabling them in this case won't speed things along. Shrink is at a lower level and having the indexes in place is just another set of pages...
March 18, 2014 at 4:00 am
Instead of trying to write your own script, I'd suggest using one that's already written. Michelle Ufford's script is available[/url] and works quite well. You can schedule it to run...
March 18, 2014 at 3:58 am
Not per se. I have a general suggestion to bump it to 35. You can get more specific and query the plans in cache to get overall costs and then...
March 17, 2014 at 12:34 pm
I think SQLBuddy hit the most important point. Backup all the indexes as scripts first. Dropping or adding an index is a pretty trivial event, but knowing exactly which index...
March 17, 2014 at 11:41 am
I'd start by identifying what is holding the lock and why it's holding it. That would be priority one. Is it an uncommitted transaction? Can you commit it? Do you...
March 17, 2014 at 10:37 am
The query above can do that. You just have to filter by the name if that's what you want.
March 17, 2014 at 10:03 am
CK2 (3/17/2014)
rraza (3/15/2014)
A DBA accidentally dropped a critical highly transactional table in production. Walk me through the exact procedure to restore it without taking...
March 17, 2014 at 7:39 am
It sounds like your SQL Agent service is offline. First, I'd attempt to restart it. Was it ever online? If so, have you recently made changes to the security settings...
March 17, 2014 at 3:30 am
Are you seeing performance issues? Have you determined that these issues are directly related to the fragmentation of the indexes? If the answer to both these is yes, then you...
March 17, 2014 at 3:26 am
That sounds like dirty data. The single best solution is to clean the data at it's source. The functions that you ran on the columns will prevent index use making...
March 16, 2014 at 4:14 am
For insert operations, frequently disabling the indexes is a good idea.
If there's a failure, no, the indexes won't automatically reenable. You'll need to make sure you have something in place...
March 16, 2014 at 4:10 am
Joy Smith San (3/15/2014)
A rollback takes as long or longer than the operation had until the point it was cancelled. You wait, because there's nothing else you can do.
Gile,
Suppose an...
March 16, 2014 at 4:05 am
Viewing 15 posts - 8,641 through 8,655 (of 22,214 total)