SQL ROW_NUMBER() Function
This tutorial shows you how to use the ROW_NUMBER() to assign a sequential number to each row in a query result set.
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.
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.
T-SQL Tutorial
T-SQL Tutorial, T-SQL (Transact-SQL) is an extension of SQL language. This tutorial covers the fundamental concepts of T-SQL such as its various functions, procedures, indexes,