Viewing 15 posts - 601 through 615 (of 49,571 total)
Script the indexes, then drop them and the clustered index and create the clustered columnstore
November 24, 2017 at 8:49 am
November 23, 2017 at 7:28 am
If you have a backup of the DB before you removed the compression, you can restore that somewhere and check what indexes were compressed and what compression they had.
November 23, 2017 at 1:00 am
Because a count(*) is asking how many rows are in the table, not the contents of the rows, and hence that can be answered with any index, as all non-filtered...
November 22, 2017 at 12:39 am
November 21, 2017 at 10:23 am
November 21, 2017 at 10:20 am
November 21, 2017 at 10:09 am
Maybe. Depends on the predicate, the index key columns and the rest of the query. It's not as simple as you're making out.
There's a lot of posts on indexes...
November 21, 2017 at 3:47 am
It's going to have to scan something, since there's no filter on that query. Optimiser calculated that a scan of the table will be the most efficient.
November 21, 2017 at 3:22 am
From the looks of it, master started and then just about everything else started...
November 20, 2017 at 11:53 pm
November 20, 2017 at 2:02 pm
November 20, 2017 at 2:01 pm
Viewing 15 posts - 601 through 615 (of 49,571 total)