Viewing 15 posts - 1 through 15 (of 21 total)
Thanks Jeff! I will defintely take a look at the scripts and approach. Appreciate the input!
October 8, 2020 at 7:42 pm
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...
October 6, 2020 at 7:42 pm
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...
October 6, 2020 at 5:14 pm
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...
September 28, 2020 at 4:22 pm
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
September 17, 2020 at 4:03 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
How can I track these down to see if these are normal locks or causing performance issues?
June 25, 2020 at 8:54 pm