Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
I want to read the book!
All characters reduced
Learn T-SQL Querying - A guide to developing efficient and elegant T-SQL code - cover

Learn T-SQL Querying - A guide to developing efficient and elegant T-SQL code

Pedro Lopes, Pam Lahoud

Publisher: Packt Publishing

  • 0
  • 0
  • 0

Summary

Data professionals seeking to excel in Transact-SQL for Microsoft SQL Server and Azure SQL Database often lack comprehensive resources. Learn T-SQL Querying second edition focuses on indexing queries and crafting elegant T-SQL code enabling data professionals gain mastery in modern SQL Server versions (2022) and Azure SQL Database. The book covers new topics like logical statement processing flow, data access using indexes, and best practices for tuning T-SQL queries.
Starting with query processing fundamentals, the book lays a foundation for writing performant T-SQL queries. You’ll explore the mechanics of the Query Optimizer and Query Execution Plans, learning to analyze execution plans for insights into current performance and scalability. Using dynamic management views (DMVs) and dynamic management functions (DMFs), you’ll build diagnostic queries. The book covers indexing and delves into SQL Server’s built-in tools to expedite resolution of T-SQL query performance and scalability issues. Hands-on examples will guide you to avoid UDF pitfalls and understand features like predicate SARGability, Query Store, and Query Tuning Assistant. 
By the end of this book, you‘ll have developed the ability to identify query performance bottlenecks, recognize anti-patterns, and avoid pitfalls
Available since: 02/29/2024.
Print length: 456 pages.

Other books that might interest you

  • Make Your Home a Nature Reserve - cover

    Make Your Home a Nature Reserve

    Donna Mullen

    • 0
    • 1
    • 0 
    Bees, butterflies, bats, badgers …
These beautiful and fascinating creatures need a little help from us, as their natural habitats are under pressure.
It's time to invite nature into your home – whether it's a window box, a suburban garden or a farm. Learn how to build a pond, make places for bats to roost and spaces for hedgehogs to ramble. Discover the amazing secret lives of Ireland's wildlife, from tiny bugs to large mammals.
Do try this at home!
    Show book
  • Making Bird-Friendly Birdhouses - Instructions and Plans for 15 Specific Birds Including Bluebirds Wrens Robins & Owl - cover

    Making Bird-Friendly Birdhouses...

    Melvin "Bird Man Mel" Toellner,...

    • 0
    • 1
    • 0 
    As popular as birdhouses are, many are designed with aesthetics in mind, rather than the bird's preferences and needs. Not so for the projects in Making Bird-Friendly Birdhouses. Lifelong birder Mel "Bird Man Mel" Toellner and pro woodworker Matt Maguire walk readers step-by-step through 15+ projects for safe birdhouses that birds find conducive to their natural nesting habitats. They begin with a comprehensive introduction to why birdhouses are so important, and why the birdhouses should be created with specific birds in mind like bluebirds, wrens, chickadees, owls and even bats! With additional sections on distribution maps, detailed plans, mounting instructions, and tips on attracting birds to your yard, it has everything you need to create a successful backyard haven for your winged friends.
    Show book