We have a department with a calendar that has over 400,000 items. We're thinking it somehow got that big due to them linking with outlook. We've turned that off but the items are still in SharePoint in the calendar. This is causing a great
deal of blocking when that calendar is accessed (CAML queries). They take several minutes to run and block anyone from doing anything in SharePoint (like saving documents or even accessing SharePoint). We'd like to just delete the 400,00+ items
but I'm not sure what all tables are involved. I've found that the tables docs and UserData each have the 400,000+ records relating to the calendar in question. I don't want to simply delete the records from these tables only. Does anyone
know what I need to do to clear the calendar? Is there a way in SharePoint to just delete the whole calendar and it delete the records where needed and then add the calendar back (and it be empty)?
View Complete Post