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

Ed Wagner (3/14/2014)

Grant Fritchey (3/14/2014)

Yeah, that one is killing me. Vague weirdness, badly edited execution plans quite literally...

Well, that's an indication anyway. Parse time includes time to check the cache, so you get some idea of how trivial that process can be. It won't always be though.

Yeah, that one is killing me. Vague weirdness, badly edited execution plans quite literally changing everything we can...

The answer is in the sys.dm_db_index_physical_stats as was outlined in the query above. You can get targeted statistics on a given index, or get all statistics on all indexes. Read...

I know you said you don't want to change the code, but it looks like there might be problematic bits in there. However, without an execution plan, I've got nothing...

Yeah, I'm with Gail on this. I spotted the one issue, but I'm pretty sure you have others. But working off this vague set of descriptions the best I can...

Hmmm... Not crazy about that approach in the script. Allen White has a script he uses to do the same thing. You might search his blog. I'll bet it's more...