SPEAKER DETAILS

img

Ami Levin

www.amilevin.com
Senior data tier architect, data modeler, database designer and SQL developer. Inventor of intelligent, autonomous performance optimization products. Designed, reviewed and optimized some of the world’s largest, most challenging, mission critical data environments. A seasoned speaker, instructor and mentor. Author of white papers and technical articles.

Sessions

Where are my (primary) keys?

Level :
Intermediate
Date :
10:45 AM Sunday
Room :
PSEC4501
Track :
SQL Server Developers and...
Interested : (-) - Registered : (30)
Tag(s) :

Speakers: Ami Levin

In this session, we revisit some of the fundamental design principals of relational databases—normalization rules, key selection, and the controversies associated with these issues—from a very hands-on, practical perspective. We also consider the benefits and challenges of using different types of keys (natural, surrogates, artificial, others) from multiple aspects, including data consistency, application development, maintenance, portability, and performance.

Details

Physical Join Operators

Level :
Intermediate
Date :
2:45 PM Sunday
Room :
5501
Interested : (-) - Registered : (16)
Tag(s) :

Speakers: Ami Levin

SQL Server implements three different physical operators to perform joins. In this session, we will examine how each of these operators works, including its advantages and challenges. Using real life examples, we will better understand the logic behind the optimizer’s decisions on which operator to use for various joins. Finally, we will learn how to avoid some common join related pitfalls and how to get better performance from our queries.

Details
  • Not Interested
  • Interested
  • Attending

SPONSORS List