Tag Info

Hot 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 ...



Only top voted, non community-wiki answers of a minimum length are eligible