Data Mozart
Data Mozart

Tag: T-SQL

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.
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.