Inside Microsoft SQL Server 2005: T-SQL Querying
- ISBN-10
- 0735623139
- ISBN-13
- 9780735623132
- Series
- Inside Microsoft SQL Server 2005
- Category
- Computers
- Pages
- 595
- Language
- English
- Published
- 2006
- Authors
- Dejan Sarka, Itzik Ben-Gan, Lubor Kollar
Description
Take 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. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language--solving complex problems with real-world solutions. Discover how to: Understand logical and physical query processing Apply a methodology to optimize query tuning Solve relational division problems Use CTEs and ranking functions to simplify and optimize solutions Aggregate data with various techniques, including tiebreakers, pivoting, histograms, and grouping factors Use the TOP option in a query to modify data Query specialized data structures with recursive logic, materialized path, or nested sets solutions PLUS--Improve your logic and get to the heart of querying problems with logic puzzles Get code and database samples on the Web
Get the book
Other editions
Similar books
-
Inside Microsoft SQL Server 2005: T-SQL Programming
By Dejan Sarka, Itzik Ben-Gan, Roger WolterProvides information on the architecture of the T-SQL programming language.
-
Inside Microsoft SQL Server 2005: Query Tuning and Optimization
By Kalen DelaneyDig into the internals of tuning and optimization features in SQL Server 2005--with insights from leading SQL Server experts. This in-depth guide delivers best practices, pragmatic advice, and code samples...
-
Microsoft SQL Server 2005 Programming For Dummies
By Andrew WattCreate and modify databases and keep them secure Get up to speed on using T-SQL to store and manipulate data SQL Server 2005 improves an already great database management system. This book shows you how to put it to work in a hurry.
-
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
By Dejan SundericYou'll learn to incorporate effective Transact-SQL stored procedures into client or middleware code, and produce CLR methods that will be compiled into CLR stored procedures. This is a must-have resource for all SQL Server 2005 developers.
-
Inside Microsoft SQL Server 2005: the storage engine zhong wen ban
By Kalen Delaney, 戴蘭妮, 張世敏Inside Microsoft SQL Server 2005: the storage engine zhong wen ban
-
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.
-
Mastering Microsoft SQL Server 2005
By Mike Gunderloy, Joseph L. Jorden, David W. Tschanz... EXEC sp_addumpdevice 'disk', 'Test_Backup', 'c:\Test_Backup.dat' BACKUP DATABASE TEST TO Test_Backup Ira-mama . '"li 3w Q ---~ I filo» 3mm 9mm Duh-Isl In' IMWITGIJ _ 'Eva —W i i _ we .9; : - 'Bi: “'1 in on' (W 'Mnngms'wnm cum 0.
-
Learning SQL on SQL Server 2005
By Sikha Saha Bagui, Richard Walsh EarpWould SELECT * FROM Student WHERE sname LIKE 'Smith%' find someone whose name is: i. LA SMITH ii. ... would not work: SELECT g.section_id FROM Grade_report g, Section t WHERE g.section_id t.section_id Explain why WHERE .
-
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 2012 Unleashed
By Ray Rankins, Paul Bertucci, Chris GallelliAll the cook books stored in the table (book_type = 'trad_cook' or 'mod_ cook') are published by a single publisher (pub_id = '0877' ). However, SQL Server stores column-level statistics on each of these columns independent of each ...