#SqlServer Interview Question : Can you define HIERARCHYID datatypes?

The  HIERARCHYID datatype introduced with the SQL Server 2008 version is a system-supplied CLR UDT that can be useful for storing and manipulating hierarchies. Continue reading #SqlServer Interview Question : Can you define HIERARCHYID datatypes?

#Thresqlips series #SqlServer : XQuery query language – Episode 4

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 #SqlServer : XQuery query language – Episode 4

#SqlServer Interview question: What aggregation functions are available in #SSAS?

SSAS supports the following types of aggregation functions for measures: Continue reading #SqlServer Interview question: What aggregation functions are available in #SSAS?

#SqlServer Interview question: What is XPath?

XPath, the XML Path Language, is a query language for selecting nodes from an XML document. In addition, XPath may be used to compute values (e.g., strings, numbers, or Boolean values) from the content of an XML document. Continue reading #SqlServer Interview question: What is XPath?

#Thresqlips series #SqlServer #XML data, PrepareDocument & Query() – Episode 3

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 #SqlServer #XML data, PrepareDocument & Query() – Episode 3

%d bloggers like this: