Category: Databases
22
Mar
How SQL Server “thinks” – Indexes & Parameter Sniffing
by Nikola
No Comments
Simple primer on index usage and parameter sniffing
11
Mar
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
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.