Skip to Content
Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance
book

Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance

by Louis Davidson
December 2020
Intermediate to advanced
1170 pages
27h 25m
English
Apress
Content preview from Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance
© Louis Davidson 2021
L. DavidsonPro SQL Server Relational Database Design and Implementationhttps://doi.org/10.1007/978-1-4842-6497-3_11

11. Data Structures, Indexes, and Their Application

Louis Davidson1  
(1)
Antioch, TN, USA
 

The best index to a person's character is how he treats people who can't do him any good, and how he treats people who can't fight back.

— Abigail Van Buren, aka Dear Abby

To me, the true beauty of the relational database engine comes from its declarative nature. As a programmer, I simply ask the engine a question, and it answers it. The questions I ask are usually pretty simple; just give me some data from a few tables, correlate it based on a column or two, do a little math perhaps, and give me back information (and naturally ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services
QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Pro SQL Server Relational Database Design and Implementation, Fifth Edition

Pro SQL Server Relational Database Design and Implementation, Fifth Edition

Louis Davidson, Jessica Moss, Foreword by Kalen Delaney
SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries
SQL Server Query Tuning and Optimization

Publisher Resources

ISBN: 9781484264973Purchase LinkPublisher Website