Tags
Search
Conference
Data warehouse designers often ignore the specific needs of an OLAP database. In this session, John will outline the best ways to optimise your relational database to support your multidimensional OLAP cubes
This session will show you how the query optimizer has been updated to work with the new SQL Server 2014 features and to provide better performance to existing ones. Topics include Hekaton, the new cardinality estimator and incremental statistics.
This session will take a look at how parallel select into can be scaled to the nth degree in SQL Server such that all available hardware resources are utilised as fully as possible.
In this humorous session I’ll be contesting many of the so called "best practices" in SQL Server and demonstrating counter arguments. Come along to see how so called "pillars" of design are starting to break down.
<<1>>