Contact me If you wish to contact me, then the best way to do it – is to write here. :) 102 thoughts on “Contact me” Glen Schwickerath January 14, 2021 at 4:17 am Help! I created a nonclustered columnstore index on a table with 240mil rows. Then, I performed many updates to the table. Subsequently, the weekly index maintenance process (Ola Hallengren) ran. Now there is a background process running (“Create Index”) that prevents me from dropping the index, dropping the table, etc. It’s also taking many locks. I just want the columnstore index to be removed, but the background process prevents any other DDL. Internet searches are not giving me any clues here. What can I do? Thanks in advance, Glen Schwickerath Loved your SQL PASS sessions. Reply ↓ Niko Neugebauer Post authorJanuary 21, 2021 at 6:31 pm Hi Glen, it is not easy from the distance to determine what is the exact cause of that background process – I would make sure that the job has ended, that Tuple Mover is not running, etc … There is a trace flag 643 that disables the tuple mover … There has been reported SOME problems with the TM on SQL 2019 … Best regards, Niko Reply ↓ Comment navigation ← Older Comments Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment Name * Email * Website Save my name, email, and website in this browser for the next time I comment.