Performance

Performance

4 bookmarks
Custom sorting
What are Columnstore Indexes? - Simple Talk
What are Columnstore Indexes? - Simple Talk
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.
·red-gate.com·
What are Columnstore Indexes? - Simple Talk
SQL Server Index Tutorial Overview
SQL Server Index Tutorial Overview
This tutorial will try to go through each type of index available in SQL Server and explain why/when each one could be used to improve your query performance.
#tsql
·mssqltips.com·
SQL Server Index Tutorial Overview
Partitioning tables in dedicated SQL pool - Azure Synapse Analytics
Partitioning tables in dedicated SQL pool - Azure Synapse Analytics
Recommendations and examples for using table partitions in dedicated SQL pool.
For optimal compression and performance of clustered columnstore tables, a minimum of 1 million rows per distribution and partition is needed. Before partitions are created, dedicated SQL pool already divides each table into 60 distributions.
If a table contains fewer than the recommended minimum number of rows per partition, consider using fewer partitions in order to increase the number of rows per partition.
#tsql
·docs.microsoft.com·
Partitioning tables in dedicated SQL pool - Azure Synapse Analytics
SQL Query Optimization: Understanding Key Principle
SQL Query Optimization: Understanding Key Principle
This guide is intended to help you gain a true understanding of SQL query speeds. It includes research that demonstrates the speed of slow and fast query typ...
·hinty.io·
SQL Query Optimization: Understanding Key Principle