Inside Microsoft SQL Server 2008: T-SQL Querying
- ISBN-10
- 0735626030
- ISBN-13
- 9780735626034
- Category
- Computers / Languages / SQL
- Pages
- 798
- Language
- English
- Published
- 2009
- Publisher
- Microsoft Press
- Author
- Itzik Ben-Gan
Description
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
Get the book
Other editions
Similar books
-
Inside Microsoft SQL Server 2008 T-SQL Querying: T-SQL Querying
By Dejan Sarka, Itzik Ben-Gan, Lubor KollarTackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL.
-
Microsoft SQL Server 2008 Management and Administration
By Ross Mistry, Hilary CotterIf you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for.
-
Inside Microsoft SQL Server 2008 T-SQL Programming: T-SQL Programming
By Greg Low, Dejan Sarka, Itzik Ben-GanGet a detailed look at the internal architecture of T-SQL with this comprehensive programming reference.
-
Microsoft SQL Server 2008 Step by Step
By Mike HotekTeach yourself SQL Server 2008—one step at a time.
-
T-SQL Querying
By Adam Machanic, Dejan Sarka, Itzik Ben-GanWrite faster, more efficient T-SQL code: Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation ...
-
Beginning Microsoft SQL Server 2008 Programming
By Robert VieiraWith this book, you will conquer the many changes and challenges of Microsoft SQL Server 2008.
-
Microsoft SQL Server 2005 Integration Services
By Kirk HaseldenThe interesting sidebars peppered throughout the book provide insight into the processes, people and decisions that yielded the final IS product.
-
Applied Microsoft SQL Server 2008 Reporting Services
By Teo LachevProvides information on the features and functions of Reporting Services to turn enterprise data into a variety of reports.
-
Microsoft SQL Server 2008 Administration with Windows PowerShell
By Ananthakumar Muthusamy, Yan PanThe definitive guide to automating SQL Server admnistration with Powershell scripts If you're a SQL Server database administrator, this book will make your life easier.
-
Programming Microsoft SQL Server 2008
By Andrew Brust, Leonard G. Lobel, Stephen ForteThis is a must-read for Microsoft .NET and SQL Server developers who work with data access—at the database, business logic, or presentation levels.