New answers tagged


I managed to find this blog post with a magick script which allegedly does the task, can't check because this seems to not work for SQL Server 2014 which I am running, query blocks waiting for a Shared Lock. Maybe someone will find it useful though so I will just leave it here. ;WITH cte AS ( SELECT object_id, index_id, partition_number, rows, ROW_NUMBER() ...

Top 50 recent answers are included