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 years, 3 months ago by  stevec883.
• This reply was modified 4 years, 3 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

Excellent thanks. This clarifies a lot and I look forward to those articles.

It sounds like, after reading both posts (Jeff and Brian), that inserting data in the middle of the...

• This reply was modified 4 years, 6 months ago by  stevec883.

If I inherit something that was built improperly, I use that as a justifiable reason to tear it down and rebuild it the correct way. I realize this is a...

• This reply was modified 4 years, 6 months ago by  stevec883.

Doing the insert statements revealed it was working just fine. Also, seeing it work in real time with the inserts and attempted inserts made it crystal clear. Added in the...

• This reply was modified 4 years, 7 months ago by  stevec883.

I see, so it just links the parent and child tables, and ensures the child can't modify that column?