Hello.
When we’re talking about Business Intelligence (BI), we straightly imagine all Kimball concepts, star-schema, the famous slow changing dimensions among others, but we forget where it all begins. Today I will talk about some basic concepts (but quite important) in database concepts before things can start serious. The key points for this post are T-SQL, Indexes, Isolations Levels and Performance.
If you know how to answer the questions below, probably you should jump straight away to my next post I am going to post regarding this category.
Review questions:
- What’s the difference between a Clustered and Non-Clustered index?
- What’s a covered index?
- What means NOLOCK in a query?
- What’s the difference between Read Committed and Serialisable?
- How do you measure the performance of a query? Continue reading “Getting Started with Business Intelligence: Data Warehouse (T-SQL, Indexes, Isolation Levels and Performance)”