18/01/2011 7:02:05 AM
Note the change of venue for January due to the flooding.
You sit there in the evenings, alone, wondering why you’re not the same as everyone else. Conformity just isn’t the same any more. Then you realise: By being unique, understanding uniqueness, and declaring yourself to be unique, you empower database developers who need to have you returned by queries from their database. After all, you’re not some broken record – you’re part of a SQL Server table.
This talk will cover the effect that uniqueness can have on queries, and show real examples of how the Query Optimizer can leverage metadata to improve performance. This talk will include a look at database design, dimension design, and even how Denali’s columnstore indexes can also impact the situation.
About the Presenter
Rob Farley runs LobsterPot Solutions, a Gold Partner SQL Server & BI consultancy in Adelaide, Australia. He presents regularly at PASS chapters and conferences such as TechEd Australia, SQL PASS and SQLBits (UK) and heads up the Adelaide SQL Server User Group. He is an MCT, has been a SQL Server MVP since 2006 and held Microsoft certifications since 1998 (including MCDBA, MCSD, MCPD, and MCITP). He has helped create several of the MCP exams and wrote two chapters for the book “SQL Server MVP Deep Dives”.
Venue: Saxons, Level 11, 300 Adelaide Street. Brisbane |
Duration Catering from 5:30PM for a 6:00PM Start (meetings typically finish at 7:30PM) |
On: Thursday, 27 January 2011