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...

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...

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...

The query above can do that. You just have to filter by the name if that's what you want.

CK2 (3/17/2014)

---

rraza (3/15/2014)

---

Can anyoine answer this interview question Please??

A DBA accidentally dropped a critical highly transactional table in production. Walk me through the exact procedure to restore it without taking...

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...

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...

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...

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...

Joy Smith San (3/15/2014)

---

Gile,

Suppose an...

The things, you don't want to just restore, because if you overwrite the existing database, you'll probably take the app offline or, lose data. So, you should find out if...

Since the wait stats are cumulative, it doesn't matter what time of day you capture them as long as you capture them the same time every day. Then you just...

Going to all databases on a server, you have to do some type of cursor. sp_msforeachdb is a good as anything.

If you have to go to lists of specific databases,...

One thing you can do to help with parallelism is change the cost threshold for parallelism from the default value. It's 5 and that's way to low for most systems....

The plans are all pretty small and nothing stands out as horrifically scary. But, the large number of scans would be very concerning for me. Granted, everything seems to be...