Tag Info

New answers tagged

2

sp_configure doesn't invalidate all stored procedure plans. sp_configure used to configure certain values which do cause plans to be invalidated. For example on my test system with nothing else running, and filtering just for cached procedure plans: --Purposely empty all buffers and cache. DO NOT RUN ON PROD!!!!!! dbcc dropcleanbuffers; --Just run something ...


1

I have a big Index Organized Table (IOT) with 74 columns Why do you think that this table is a candidate for an IOT? IMHO, IOT's are meant to be narrow tables that don't change often. I have done testing with narrow tables and have found IOT's to do inserts at a slower rate than a traditional table with indexes. You may want to start by recreating this ...


0

For now, the issue has been addressed by: Converting AllEligibleEntries to a temporary table Converting NumberOfEligibleEntries to a local variable, obtained from a select on the temporary table Converting SelectedEntries to a DELETE WHERE NOT BETWEEN operation on the temporary table Keeping the remaining CTEs as-is. Performance is measurably better (a ...



Top 50 recent answers are included