The E, the A and the V - sqlTopia

[Pages:46]The E, the A and the V

How I Learned to Stop Worrying and Love the Hybrid

Evaluation Forms

? Don't forget to fill out the evaluation forms

? Speakers ? Sponsors ? Event

Transact-SQL Guru

? Core competencies

? Algorithms ? Query tuning ? Database design

? Known for

? Unorthodox ideas ? Thinking outside the box ? "The guy other MVPs turn to for help" ? Passionate about the Community

Content Disclaimer

? Protecting privacy

? Classified information ? Data may be obfuscated ? Diagrams may be conceptual

? Transactional data is 500 TB

? Total database size is 1.5 PB

? Continuous improvements

Background

? Bad database design ? Slow algorithm ? Inefficient storage planning

2=0.9738

1

2

3

4

5

6

7

8

9 10

SQL Server MVP Deep Dives 2



Where in the World is Isabelle?

Larsson Navarez

Smirnov Cho

The Simplest Relational Division There Is

FamilyName

Navarez Larsson Larsson Larsson Larsson Smirnov Smirnov Smirnov Cho Cho

FirstName

Emilia Filippa Isabelle Samuel Cecilia Isabelle Alexander Maxim Aoi Hiroto

Age SELECT FamilyName 12 FROM dbo.Families 10 WHERE FirstName = 'Isabelle'

6

4

3

9

7

2

6

4

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download