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?
Tag Archives: Sql Server Tutorials
#Thresqlips series #XML, Auto & Path – Episode 2
Welcome back to the weekly #thresqlips series comprising of three sql tips, definitions or “must-know”‘s that should be part of your database development vocabulary: Continue reading #Thresqlips series #XML, Auto & Path – Episode 2
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 question: Data deletion / Size reduction
Question: When you delete data from a table, is SQL Server reducing immediately the size of that table? Continue reading Sql Server Interview question: Data deletion / Size reduction
Free eBook – Introducing Microsoft SQL Server 2012 #sqlserver2012
Microsoft SQL Server 2012 is Microsoft’s first cloud-ready information platform. It gives
organizations effective tools to protect, unlock, and scale the power of their data, and it works
across a variety of devices and data sources, from desktops, phones, and tablets, to datacenters and
both private and public clouds. Continue reading Free eBook – Introducing Microsoft SQL Server 2012 #sqlserver2012