Data Mozart

Category: T-SQL

28 May
Data Modeling Databases Relational Databases SQL Server T-SQL

Datetime2 – Why you should (not) use it

by Nikola
5 Comments
Choosing right data type is not so straightforward as you might think at first sight
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.