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, 9 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, 10 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, 10 months ago by  stevec883.

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

I think I have it. Build the DMK and restore all the others.

Thanks for the info. I think I might give some thought into just doing those 2 exams before the end of Jan and having the "legacy" cert, that will go...