Viewing 15 posts - 31 through 45 (of 47 total)
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...
September 25, 2020 at 2:54 am
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...
September 19, 2020 at 1:03 pm
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...
September 18, 2020 at 8:41 pm
Thanks for the helpful info - I will look into all of these suggestions.
August 6, 2020 at 7:38 pm
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...
July 9, 2020 at 3:50 pm
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...
July 9, 2020 at 3:22 pm
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...
July 8, 2020 at 6:49 pm
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"...
July 8, 2020 at 4:43 pm
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...
June 28, 2020 at 2:55 pm
June 25, 2020 at 8:54 pm
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...
June 4, 2020 at 7:33 pm
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...
May 30, 2020 at 5:46 pm
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...
May 8, 2020 at 6:52 pm
I see, so it just links the parent and child tables, and ensures the child can't modify that column?
May 7, 2020 at 6:44 pm
Viewing 15 posts - 31 through 45 (of 47 total)