Category: Databases

22 Mar

Databases Relational Databases SQL Server T-SQL

How SQL Server “thinks” – Indexes & Parameter Sniffing

by Nikola

No Comments

Simple primer on index usage and parameter sniffing

11 Mar

Databases Relational Databases SQL Server T-SQL

Indexing for better performance – real use case

by Nikola

No Comments

Indexing is always a trade-off between performance gain and maintenance overhead.

28 Dec

Databases SQL Server T-SQL

Secret life of CTEs

by Nikola

1 Comment

Common Table Expressions (CTEs for friends) is one of the most powerful, but still much underestimated, techniques in T-SQL.