Contact me

If you wish to contact me, then the best way to do it – is to write here. :)

102 thoughts on “Contact me

  1. Glen Schwickerath

    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.

    1. Niko Neugebauer Post author

      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

Leave a Reply to Frank L. Cancel reply

Your email address will not be published. Required fields are marked *