Category: Relational Databases

19 May

Relational Databases SQL Server T-SQL

Island adventures with T-SQL Window Functions

by Nikola

1 Comment

Traditional "Gaps and Islands" problem can be easily solved using T-SQL Window Functions

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.