February 2011 - Posts

• Fast Track Data Warehouse 3.0 Reference Guide

  Microsoft just release Fast Track Data Warehouse 3.0 Reference Guide version. The new changes are increased memory recommendation and the disks per RAID group change from 2-disk RAID 1 to 4-Disk RAID 10. Memory The earlier FTDW reference architecture Read More... Posted Thursday, February 24, 2011 9:48 AM by jchang | 8 Comments

• Columnar Databases

  Ingres just published a TPC-H benchmark for VectorWise , an analytic database technology employing 1) SIMD processing (Intel SSE 4.2), 2) better memory optimizations to leverage on-chip cache, 3) compression, 4) Column-based storage. Ingres originated Read More... Posted Monday, February 14, 2011 10:24 AM by jchang | 7 Comments

• SIMD Extensions for the Database Storage Engine

  For the last 15 years, Intel and AMD have been progressively adding special purpose extensions to their processor architectures. The extensions mostly pertain to vector operations with Single Instruction, Multiple Data (SIMD) concept. The reasoning was Read More... Posted Monday, February 07, 2011 8:23 AM by jchang | 5 Comments Filed under: storage engine, cpu

• Free tools for SQL Server - Automating Execution Plan Analysis

  Since this topic is being discussed, I will plug my own tools, SQL Exec Stats and (a little dated) documentation the main capability is cross-referencing index usuage with specific execution plans. another feature is generating execution plans for all Read More... Posted Sunday, February 06, 2011 6:02 PM by jchang | 1 Comments Filed under: Free Tools