Category Archives: Sql Server 2012

#SqlServer Interview question: What is Usage Based Optimization in SSAS? How is it performed?

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?

#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

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?

#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

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