BIBLIO is the largest independent book marketplace in the world, with over 100 million books.

Skip to content

T-SQL Querying
Stock photo: cover may vary

T-SQL Querying Paperback - 2015

by Itzik Ben-Gan; Adam Machanic; Dejan Sarka

Add to wish list

Reader reviews for T-SQL Querying

Write a review for this book

There are no reviews for this book yet. Be the first to write a review!

Your review will be anonymous unless you login or create an account first.

Overall rating
Remember: You’re rating the book as a work, not the seller or the condition of the specific copy you purchased!

Important Terms and Guidelines

  • Please focus on the book’s content and context. Also, add any personal comments as to how you enjoyed the book. Substantiate your likes and dislikes. You may make comparisons to other books.
  • Reviews must be at least 140 characters in length.
  • Please do not reveal critical plot elements.
  • This is not a help line. Contact customer support if you need help.
Your review must not include:
  • Obscenities, discriminatory language, or other insulting language not suitable for public domain
  • Advertisements, “spam” content, or references to other products, offers or websites.
  • Email addresses, URLs, phone numbers, physical addresses or other contact information.
  • Overly critical comments about other reviews or reviewers
  • Time-sensitive material (i.e. promotional tours, seminars, lectures, etc.)
  • Availability, price, or alternative ordering/shipping information

From the publisher

T-SQL insiders help you tackle your toughest queries and query-tuning problems
Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL's internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012.

Write 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 techniques, including new grouping sets
  • Efficiently perform data-analysis calculations
  • Make the most of T-SQL's optimized bulk import tools
  • Avoid date/time pitfalls that lead to buggy, poorly performing code
  • Create optimized BI statistical queries without additional software
  • Use programmable objects to accelerate queries
  • Unlock major performance improvements with In-Memory OLTP
  • Master useful and elegant approaches to manipulating graphs

About This Book
  • For experienced T-SQL practitioners
  • Includes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL Programming
  • Valuable to developers, DBAs, BI professionals, and data scientists
  • Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics

Details

  • Title T-SQL Querying
  • Author Itzik Ben-Gan; Adam Machanic; Dejan Sarka
  • Binding Paperback
  • Edition 1st edition
  • Pages 864
  • Volumes 1
  • Language ENG
  • Publisher Microsoft Press
  • Publication date 2015-03-16
  • Features Index
  • ISBN 9780735685048 / 0735685045
  • Weight 3 lbs (1.36 kg)
  • Dimensions 9 x 7.3 x 1.6 in (22.86 x 18.54 x 4.06 cm)
  • Category Computers - Data Base Management
  • Library of Congress subjects SQL (Computer program language), Query languages (Computer science)
  • Dewey Decimal Code 005.758

About the author

Itzik Ben-Gan is a mentor for and co-founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik has authored several T-SQL books as well as articles for SQL Server Pro, SolidQ Journal, and MSDN. Itzik's speaking activities include TechEd, SQLPASS, SQL Server Connections, SolidQ events, and various user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning, and T-SQL Fundamentals courses, along with being a primary resource within the company for its T-SQL-related activities.

Dejan Sarka, MCT and SQL Server MVP, is an independent consultant, trainer, and developer focusing on database and business intelligence applications. His specialties are advanced topics like data modeling, data mining, and data quality. On these tough topics, he works and researches together with SolidQ and the Data Quality Institute. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of 11 books about databases and SQL Server, with more to come. He also has developed and is continuing to develop many courses and seminars for SolidQ and Microsoft. He has been a regular speaker at many conferences worldwide for more than 15 years, including Microsoft TechEd, PASS Summit, and others.

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has contributed to several books on SQL Server, including T-SQL Querying (Microsoft Press, 2015) and SQL Server 2008 Internals (Microsoft Press, 2009). He regularly speaks at international conferences and training events on a variety of SQL Server topics.

Kevin Farlee has over 25 years in the industry, in both database and storage-management software. In his current role as a Storage Engine Program Manager on the Microsoft SQL Server team, he brings these threads together. His current projects include the SQL Server Project "Hekaton" In-Memory OLTP feature.

Back to top↑

More Copies for Sale

Show all copies
T-SQL Querying (Developer Reference)
Stock photo: cover may vary

T-SQL Querying (Developer Reference)

by Ben-Gan, Itzik,Machanic, Adam,Farlee, Kevin,Sarka, Dejan

  • Used
  • Good
  • Paperback
Condition
Good
Binding
Paperback
ISBN 10 / ISBN 13
9780735685048 / 0735685045
Quantity available
1
Seller
Evergreen Goodwill
Item price
A$10.42
A$5.66 Delivery to USA

Show details

Description:
Microsoft Press, 3/6/2015 12:00:01 AM. paperback. Good. 1.8110 in x 9.1339 in x 7.4016 in.
Add to wish list
Item price
A$10.42
A$5.66 Delivery to USA
T-SQL Querying (Developer Reference)
Stock photo: cover may vary

T-SQL Querying (Developer Reference)

by Ben-Gan, Itzik

  • Used
  • Paperback
  • first
Condition
Used
Edition
1
Binding
Paperback
ISBN 10 / ISBN 13
9780735685048 / 0735685045
Quantity available
1
Seller
Ergodebooks
Item price
A$15.84
Free Delivery to USA

Show details

Description:
Microsoft Press, 2015-03-06. 1. paperback. Used: Good. 7.40x1.95x9.00. Buy with confidence. Excellent Customer Service & Return policy.
Add to wish list
Item price
A$15.84
Free Delivery to USA
T-SQL Querying (Developer Reference)
Stock photo: cover may vary

T-SQL Querying (Developer Reference)

by Farlee, Kevin,Sarka, Dejan,Machanic, Adam,Ben-Gan, Itzik

  • Used
  • Very good
  • Paperback
Condition
Very good
Binding
Paperback
ISBN 10 / ISBN 13
9780735685048 / 0735685045
Quantity available
1
Seller
Schwabe Books
Item price
A$36.06
A$7.08 Delivery to USA

Show details

Description:
Microsoft Press, 2015-03-06. Paperback. Very Good. 1.9300 9.0600 7.4800.
Add to wish list
Item price
A$36.06
A$7.08 Delivery to USA
T-SQL Querying (Developer Reference)
Stock photo: cover may vary

T-SQL Querying (Developer Reference)

by Ben-Gan, Itzik

  • Used
  • Good
  • Paperback
Condition
Good
Binding
Paperback
ISBN 10 / ISBN 13
9780735685048 / 0735685045
Quantity available
1
Seller
Bonita
Item price
A$47.53
Free Delivery to USA

Show details

Description:
paperback. Good. Access codes and supplements are not guaranteed with used items. May be an ex-library book.
Add to wish list
Item price
A$47.53
Free Delivery to USA
T-SQL Querying (Developer Reference)
Stock photo: cover may vary

T-SQL Querying (Developer Reference)

by Ben-Gan, Itzik

  • New
  • Paperback
  • first
Condition
New
Edition
1
Binding
Paperback
ISBN 10 / ISBN 13
9780735685048 / 0735685045
Quantity available
1
Seller
Ergodebooks
Item price
A$55.19
Free Delivery to USA

Show details

Description:
Microsoft Press, 2015-03-06. 1. paperback. New. 7.40x1.95x9.00. Buy with confidence. Excellent Customer Service & Return policy.
Add to wish list
Item price
A$55.19
Free Delivery to USA
T-SQL Querying (Developer Reference)
Stock photo: cover may vary

T-SQL Querying (Developer Reference)

by Ben-Gan, Itzik; Machanic, Adam; Sarka, Dejan; Farlee, Kevin

  • Used
  • Good
  • Paperback
Condition
Good
Binding
Paperback
ISBN 10 / ISBN 13
9780735685048 / 0735685045
Quantity available
2
Seller
SGS Trading Inc
Biblio Top Seller
Item price
A$66.82
A$5.53 Delivery to USA

Show details

Description:
Microsoft Press, 2015-03-06. Paperback. Good. Textbook, May Have Highlights, Notes and/or Underlining, BOOK ONLYNO ACCESS CODE, NO CD, Ships with Emailed Tracking
Add to wish list
Item price
A$66.82
A$5.53 Delivery to USA
T-Sql Querying
Stock photo: cover may vary

T-Sql Querying

by Ben-Gan, Itzik; MacHanic, Adam; Sarka, Dejan; Farlee, Kevin,

  • New
Condition
New
ISBN 10 / ISBN 13
9780735685048 / 0735685045
Quantity available
5
Seller
GreatBookPrices
Item price
A$78.44
A$5.66 Delivery to USA

Show details

Description:
new.
Add to wish list
Item price
A$78.44
A$5.66 Delivery to USA
T-Sql Querying
Stock photo: cover may vary

T-Sql Querying

by Ben-Gan, Itzik; MacHanic, Adam; Sarka, Dejan; Farlee, Kevin,

  • Used
Condition
New
ISBN 10 / ISBN 13
9780735685048 / 0735685045
Quantity available
5
Seller
GreatBookPrices
Item price
A$78.44
A$5.66 Delivery to USA

Show details

Description:
like new.
Add to wish list
Item price
A$78.44
A$5.66 Delivery to USA
T-SQL Querying
Stock photo: cover may vary

T-SQL Querying

by Ben-gan, Itzik/ Machanic, Adam/ Sarka, Dejan/ White, Paul

  • New
  • Paperback
Condition
New
Binding
Paperback
ISBN 10 / ISBN 13
9780735685048 / 0735685045
Quantity available
2
Seller
Revaluation Books
Item price
A$140.23
A$47.74 Delivery to USA

Show details

Description:
Microsoft Pr, 2015. Paperback. New. 1st edition. 864 pages. 9.25x7.75x2.25 inches.
Add to wish list
Item price
A$140.23
A$47.74 Delivery to USA
T-SQL Querying
Stock photo: cover may vary

T-SQL Querying

by Pearson Education

  • New
Condition
New
ISBN 10 / ISBN 13
9780735685048 / 0735685045
Quantity available
100
Seller
Ubiquity Trade
Biblio Top Seller
Item price
A$109.70
A$4.25 Delivery to USA

Show details

Description:
New.
Add to wish list
Item price
A$109.70
A$4.25 Delivery to USA
Show all copies
Back to top↑

Please wait a moment while we load the requested page.