SQL
Using CTE (Common Table Expression) to achieve lazy loading and querying infinite hierarchical data structure
July 25, 2023
Program
Recording the backend implementation of Lazy loading querying infinite hierarchical data structure.
Database Query Performance Optimization Tips : Index Concepts, Clustered, Non-Clustered
June 13, 2023
Program
Recording tips for optimizing query performance through indexing, differences between clustered and non-clustered indexes.
Database Query Performance Optimization Tips : Statement Optimization, Adding Indexes
March 29, 2023
Program
As the system data grows increasingly large, it's common to encounter situations where database queries take too long. This article provides several methods for optimizing database query performance.
SQL SCOPE_IDENTITY() and @@IDENTITY Differences in Retrieving Auto-Increment Values
March 20, 2023
Program
Retrieve the Most Recently Added Data in SQL
SQL-implement data partitioning (partition by)
February 7, 2023
Program
Implement data partitioning using SQL partition by and compare the performance with LINQ.