Optimizing SQL Server index strategies
SQL Shack
JULY 2, 2019
Index strategies overview This article is about techniques for optimizing the SQL Server indexes strategy. Furthermore, I also presented an […].
optimizing-sql-server-index-strategies 
51 
Islands T-SQL Challenge
SQL Performance
APRIL 13, 2022
However, these techniques require explicit sorting despite the presence of a supporting index. Note the definition of the primary key constraint based on the composite key (grp, ord), which results in a clustered index based on the same key. This index can potentially support window functions partitioned by grp and ordered by ord.
Join 5,000+
Insiders
Sign Up for our Newsletter
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Trending Sources
MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance
Percona
SEPTEMBER 1, 2023
MySQL performance tuning offers several significant advantages for effective database management and optimization. Reduced Resource Usage Optimizing resource-intensive queries and configurations can lead to a reduced burden on your server. It is crucial to identify and rectify these issues to optimize your database fully.
Matching Supply With Demand — Solutions, Part 1
SQL Performance
JANUARY 12, 2022
It so happens that the classic predicate-based technique for identifying interval intersection has poor performance since there's no good indexing scheme to support it. Here's the code to create such an index: CREATE UNIQUE NONCLUSTERED INDEX idx_Code_ID_i_Quantity ON dbo. Interval Intersections Using CTEs.
Master MySQL Point in Time Recovery
Scalegrid
MARCH 8, 2024
This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively without overwhelming you with complexity. Three distinct modes are available within MySQL when setting up your binary logs’ format.
Optimize MongoDB® Pagination
Scalegrid
DECEMBER 28, 2023
But how does MongoDB handle pagination, and how can you optimize it for better performance? Implementing pagination can be done using two primary strategies: offset-based and cursor-based methods. Cursor-Based Pagination When dealing with big datasets, offset-based pagination can be less than optimal.
Number series generator challenge solutions – Part 3
SQL Performance
MARCH 10, 2021
You can read about the fundamentals of column elimination logic with table expressions in Fundamentals of table expressions, Part 3 – Derived tables, optimization considerations under “Column projection and a word on SELECT *.”. As a reminder, this solution uses a join with a dummy table that has a columnstore index to get batch processing.
Let's personalize your content