New posts in Performance Tuning

How to most efficiently find out if a record has child records?

SQL Relationship between Subtree Cost and Performance Time

'SELECT TOP' performance question

Do triggers compile each time?

Huge "Network I/O" type resource waits

Cardinality Estimation for >= and > for intra step statistics value

Large (>22 trillion items) geospatial dataset with rapid (<1s) read query performance

SQL perf issue - configure server correctly first or troubleshoot issues one by one?

Why does adding a TOP 1 dramatically worsen performance?

Speed up creation of Postgres partial index