Inside Microsoft SQL Server 2008 T-SQL Querying: T-SQL Querying
- ISBN-10
- 0735638306
- ISBN-13
- 9780735638303
- Category
- Computers
- Pages
- 832
- Language
- English
- Published
- 2009-03-25
- Publisher
- Microsoft Press
- Authors
- Dejan Sarka, Itzik Ben-Gan, Lubor Kollar
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
Similar books
-
Inside Microsoft SQL Server 2008: T-SQL Querying
By Itzik Ben-GanTackle 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...
-
Microsoft SQL Server 2008 T-SQL Fundamentals
By Itzik Ben-GanMaster the foundations of T-SQL with the right balance of conceptual and practical content.
-
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 ...
-
Microsoft SQL Server 2012 T-SQL Fundamentals
By Itzik Ben-GanGain a solid understanding of T-SQL—and write better queries Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2012.
-
Inside Microsoft SQL Server 2008: T-SQL Programming
By Itzik Ben-GanGet a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the...
-
Inside Microsoft SQL Server 2005: T-SQL Querying
By Dejan Sarka, Itzik Ben-Gan, Lubor KollarTake a detailed look at the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from the experts.
-
Microsoft SQL Server 2008 Step by Step
By Mike HotekTeach yourself SQL Server 2008—one step at a time.
-
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.
-
Microsoft SQL Server 2008 Internals
By Kalen Delaney, Adam Machanic, Conor CunninghamDelve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts.
-
Practical SQL Queries for Microsoft SQL Server 2008 R2
By Art TennickThe application, syntax, and results of each query are described in detail. The book emphasizes SQL for use in SSMS, but the queries also apply to SSRS, WinForms, WebForms, and many other applications.