Learn T-SQL Querying : A guide to developing efficient and elegant T-SQL code /: A guide to developing efficient and elegant T-SQL code. (2019)

• Record Type: Book
• Further Information: Note: Pedro Lopes, Pam Lahoud.
• Authors: Lopes, Pedro; Lahoud, Pam
• Contents: Table of ContentsAnatomy of a QueryUnderstanding Query ProcessingMechanics of the Query OptimizerExploring Query Execution PlansWriting Elegant T-SQL QueryEasily Identified T-SQL Anti-PatternsDiscovering T-SQL Anti-Patterns in DepthBuilding Diagnostic Queries Using DMVs and DMFsBuilding xEvent Profiler TracesComparative Analysis of Query PlansTracking Query Performance History with the Query StoreTroubleshooting Live QueriesManaging Optimizer Changes With the Query Tuning Assistant.
• Publisher Details: Birmingham : Packt Publishing
• Publication Date: 2019
• Extent: 1 online resource (484 pages)
• Subjects: Computers -- Database Management -- Data Mining; Computers -- Data Modeling & Design; Database design & theory; Data mining; Information architecture; Computers -- Data Processing; Data capture & analysis
• Languages: English
• ISBNs: 9781789342970
• Related ISBNs: 178934297X; 9781789348811
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.