SQL Server, Columnstore, Data Platform & Community
Contact me
If you wish to contact me, then the best way to do it – is to write here. :)
109 thoughts on “Contact me”
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.
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 …
Just dropping a note that I landed here to read an article linked by Brent Ozar and the color contrast between background and font is just too low for me to read comfortably. A ratio of 4.48 is right at the edge of the minimum guideline of 4.5:1 but you might want to consider bumping it higher than that to optimize for a variety of monitors/brightness levels.
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.
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
hi niko,
I prepared the first content about Azure Arc in Turkey. In the near future, I am preparing a book containing a local narrative on the subject.
Can you support me on this path? How can you support?
https://www.caglarozenc.com/azure-arc-data-services
What is the latest version of Google Analytics Source for SSIS and is there any licensing cost?
Hi Gary,
I have no clue, to be honest.
Best regards,
Niko
Your SSL Cert has expired
Hi Jeff,
yeap – hopefully will fix it soon.
Best regards,
Niko
Hi,
I would like contact you regarding a business opportunity.
Could you please send me a mail messages.
Thanks,
Damir
Just dropping a note that I landed here to read an article linked by Brent Ozar and the color contrast between background and font is just too low for me to read comfortably. A ratio of 4.48 is right at the edge of the minimum guideline of 4.5:1 but you might want to consider bumping it higher than that to optimize for a variety of monitors/brightness levels.