In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.

Sometimes some piece of T-SQL slips by, or falls out of memory.Come and revisit old favorites, and brush up on new T-SQL features and enhancements.This session is chock full of code examples, including before-and-after demos and how-to illustrations.