Category: Databases

11 Aug

Rows or Columns – where should I put my index on?

by Nikola

No Comments

Choosing optimal indexing strategy for your SQL Server workloads is one of the most challenging tasks. Learn in which scenarios you can benefit from using...

14 Jun

Databases SQL Server T-SQL

Azure Data Studio or SSMS – which should I use?

by Nikola

2 Comments

Azure Data Studio or SSMS? Why can't be Azure Data Studio AND SSMS? Check how you can take the best from both worlds

05 Jun

Databases SQL Server T-SQL

How (not) to kill your SQL Server performance with implicit conversion

by Nikola

No Comments

Learn how to avoid performance killer and help SQL Server choose optimal execution plan for your queries

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

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.