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: Thresqlips
#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
#Thresqlips series Metadata, XML & Text files – Episode 1
Welcome to the first article of 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 Metadata, XML & Text files – Episode 1