Yes, we're already running the CTP versionYes, our development and testing is completeNo, we're using SQL 2005, but will upgrade laterNo, we're using SQL 2005 and don't plan to upgradeNo, we're using SQL 2000 and will upgradeNo, we're using SQL 2000 and don't plan to upgradeWhat's SQL Server 2008??[show results]

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