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?
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
When working on the design and implementation of a data-warehouse / business intelligence solution some of the most common questions that I receive are in relation to the ODS or Operational Data Store. In today’s post I’ll explain it’s purpose and the proper way to interact with it.
The definition of the Operational Data Store Continue reading What an ODS is and how should you use it
In order to find all the tables without indexes just run the following query in the Query Editor:
Continue reading How can you find tables without indexes?
Question : What is a covered index?
A covered index can satisfy a query just by its index keys without having the need to touch any data pages. When an Index covers the query in this way it is a called covering index. Continue reading Sql Server Interview question: What is a covered index?