This talk covers the new columnstore feature in SQL Server 2012, which drastically improves performance for data warehouse queries. I’ll take the feature apart to not only discuss the layout of these indexes, but also their optimization with batch mode processing inside the query itself. I’ll also d...
More...
The addition of spatial data to SQL Server 2008 is one of the most important in terms of new clients and the introduction as a new type of application, as well as integration in line-of-business applications. But SQL Server 2008 was just the beginning, and there are some impressive new features and ...
More...