Thanks Jeff! I will defintely take a look at the scripts and approach. Appreciate the input!

Having been a sys admin for a long time, I do understand the separate worlds of developers vs everyone else, but sounds like a plan! I'll let you know how...

Thanks for your feedback Grant, and for confirming my suspicion. I was noticing the many many duplicate suggestions and thought it seemed extremely generic in nature. It seems it wants...

Very useful information --- I will keep that in mind, to not degrag an index that has the server default (of O% fill factor). I also like your % numbers...

Thanks for your take Jeff. I did look into it much more and realized it's mainly about HOW the page is used (as you touched on). After some reading, I...

• This reply was modified 4 months ago by  stevec883.
• This reply was modified 4 months ago by  stevec883.

I did get the table name to work --- will need to play around with it to get the database name, and the index name to be helpful.

In regards to...

Thanks Brian. I don't mind the CPU and resource utilization. I do see what you mean about the fill factor though. I think defragmenting these is a good starting point...

Thanks Sterling

Thanks for the helpful info - I will look into all of these suggestions.

Glad to know it wasn't something I was overlooking. I like the idea of moving this data to a new table, and then back again to one with the same...

I dropped the index (and primary key constraint). When I try to re-add the primary key, I received an error that there are duplicate values. I did indeed find duplicate...

Thanks for the insight Jeffrey. I did try a rebuild and ran DBCC again and it reveals the same error. Luckily, this table (and database) can afford to lose some...

Thanks Steve, I will read that article. I have also found some blogs that also suggest that it is a drop and recreate so that the index will not "rebuild"...

Thanks Jeffrey, I realize the app slowness probably has nothing to do with the database. I'm just trying to gain insight on how to dig into the issues the database...

How can I track these down to see if these are normal locks or causing performance issues?

I'm no