March 2009
Intermediate to advanced
832 pages
23h 49m
English
book
Inside Microsoft® SQL Server® 2008: T-SQL Querying
by Lubor Kollar Itzik Ben-Gan Dejan Sarka, and Steve Kass
Overview
Tackle the toughest set-based querying and query tuning
problems—guided by an author team with in-depth, inside
knowledge of T-SQL. Deepen your understanding of architecture and
internals—and gain practical approaches and advanced
techniques to optimize your code’s performance.
Discover how to:
Move from procedural programming to the language of sets and logic
Optimize query tuning with a top-down methodology
Assess algorithmic complexity to predict performance
Compare data-aggregation techniques, including new grouping sets
Manage data modification—insert, delete, update, merge—for performance
Write more efficient queries against partitioned tables
Work with graphs, trees, hierarchies, and recursive queries
Plus—Use pure-logic puzzles to sharpen your problem-solving skills
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
O’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.
I 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.
I’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.
I'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.