Usage Based Optimization is the process of defining aggregation design based on the actual queries executed by the users/applications accessing the cube, which is captured using a log. Continue reading #SqlServer Interview question: What is Usage Based Optimization in SSAS? How is it performed?
Category Archives: SQL Azure
SSAS Interview question: What are aggregates? What is the purpose of defining an aggregation design in Analysis Services?
Aggregates are summarized values, each of which corresponds to a combination of an attribute from each dimension and a measure group. An aggregate in SSAS is the differentiating factor between OLAP and OLTP, and is the fundamental principle of SSAS/OLAP, which offers blazing fast performance. Continue reading SSAS Interview question: What are aggregates? What is the purpose of defining an aggregation design in Analysis Services?
Sql Server Interview questions: What is the XML datatype?
The XML datatype holds and understands valid XML streams pretty much the same way that integers hold numbers with no decimal points, varchars hold strings of varying length, and the Geography datatype holds a position on the earth. Continue reading Sql Server Interview questions: What is the XML datatype?
How to implement a Credit Risk Data Warehouse – Part 2
In How to implement a Credit Risk Data Warehouse – Part 1 I did an overview and an executive summary of the activities required for the delivery of Credit Risk Data Warehouse project. If you haven’t read this already I recommend you read How to implement a Credit Risk Data Warehouse – Part 1 first.
In addition to the above, the DW Architect, Project Manager & their teams will have to work and define the implementation approach, which will allow the Implementation team to complete the work on an accelerated timeline.
Usually a multistage “work breakdown structure” approach for the implementation phases of the project is preferred. Continue reading How to implement a Credit Risk Data Warehouse – Part 2
Sql Interview question: What are the limitations of indexed views?
Some of the limitations with Indexed views are:
- The UNION operation is not allowed in an indexed view.
- We cannot create an Index on a nested view scenario which means we cannot create index on a view built from another view.
Continue reading Sql Interview question: What are the limitations of indexed views?