Columnstore Indexes are Finally Sorted in SQL Server 2022
There’s a widespread misconception that SQL Server’s columnstore indexes are like an index on every column.
2022-07-22
ColumnStore Index
2022-06-20
505 reads
2022-06-06
403 reads
2022-05-23
429 reads
2021-02-11
384 reads
2020-02-25
731 reads
What are Columnstore Indexes?
Microsoft continues to enhance the performance of SQL Server with new features. In this article, Monica Rathbun explains how to work with columnstore indexes, a different way to store tables that can drastically improve the performance of specific workloads.
2019-08-06
Update Statistics on a Columnstore index failed
SQL Server relies upon good, up-to-date statistics when creating query execution plans. Out-of-date statistics can cause queries to run slowly, or suddenly start consuming far more resources than is...
2019-04-17
2018-12-27
619 reads
2018-05-03
783 reads
Blogs
Connect With More Clients: Our Partner Directory Has Arrived
By Rob Sewell
The partner directory connects your agency with new customers.
Can You See Who Forced a Plan
I had an excellent group of people in Gothenburg Sweden when I taught there...
Monday Monitor Tips–Finding CUs for My Instance
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
SSISDB: finding executions from an Execute Package Task
I am trying to find usage and non-usage of package sin my ssisdb catalog....
workaround for problems that cant be try caught
hi a peer of mine recalls an error in an edi app that often...
Question of the Day
Trigger Order III
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers