SQL Server Performance Tuning

This category contains 2 posts

Clustered Index and Non-Clustered Index

As developers, we often use the clustering index and non-clustered index, if I ask most people the following two questions may have few satisfactory answers. What is the clustering index (clustered index) / What is non-clustering index (nonclustered index)? clustered index and non-clustered index What is the difference? In fact, the index can be understood … Continue reading

Four advanced features SQL Server index

Index Building Filter (filter when the index is created) There are some very inefficient index, such as regular query the status of ongoing orders, order 99% of the state is complete, one percent is in progress, so we built an index on the order status field, performance is improved, but the feeling in the index … Continue reading