Tag: Relational Database
05
Sep
3 reasons to use views instead of tables in Power BI!
by Nikola
6 Comments
When using a relational database as the data source for Power BI solutions, most report creators choose to take an easier path - import the...
22
Mar
How SQL Server “thinks” – Indexes & Parameter Sniffing
by Nikola
No Comments
Simple primer on index usage and parameter sniffing
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.