Tag: Relational Database
3 reasons to use views instead of tables in Power BI!
When using a relational database as the data source for Power BI solutions, most report creators choose to take an easier path - import the...
How SQL Server “thinks” – Indexes & Parameter Sniffing
Simple primer on index usage and parameter sniffing
Secret life of CTEs
Common Table Expressions (CTEs for friends) is one of the most powerful, but still much underestimated, techniques in T-SQL.