Best practices and limitations for columnstore indexes can be found here. My post on insert and update performance is here and my post on Archival Compression mode is here. The Microsoft Research white paper on this topic can be found here. The Fast Track Data Warehouse Reference Architecture is here.
Month: November 2013
Scripts to come.. Script file for the run once script to do all of this is here. The script to do the installation and the ini file to drive it, is here.
Quorum in a cluster is a very important concept—generally speaking, a majority of the cluster nodes, or more likely a majority of the cluster nodes must be up in order to start your cluster. This is done by design, in order to prevent what is known as “split-brain” syndrome, which is where the each half […]