- Browse
- » Microsoft SQL server 2017 on Linux
Microsoft SQL server 2017 on Linux
Author
Publisher
McGraw-Hill Education
Publication Date
[2018]
Language
English
Description
Loading Description...
More Details
ISBN
9781260121131
9781260121148
9781260121148
Table of Contents
From the eBook
Cover
Title Page
Copyright Page
Dedication
Contents
Foreword
Acknowledgments
Introduction
Chapter 1 SQL Server on Linux: Getting Started
Creating a Virtual Machine
Step 1. Basics: Configure Basic Settings
Step 2. Size: Choose Virtual Machine Size
Step 3. Settings: Configure Optional Features
Step 4. Summary and Purchase
Installing SQL Server
Configuring SQL Server
Intro to Unix Commands
Connecting to SQL Server
Installing Additional Components
Installing on Ubuntu
Installing on SUSE Linux Enterprise Server
Running SQL Server on Docker
Uninstalling SQL Server
Summary
Chapter 2 How SQL Server on Linux Works
The Sybase Years
SQLOS
The Industry Changes
Project Helsinki
A Virtualization Surprise
Drawbridge
Looking for a Shortcut
SQLPAL
Summary
Chapter 3 Linux for the SQL Server Professional
Getting Started
Files and Directories
Files
The Unix File System
Additional Commands
Building a Command
Permissions
Bash Shell
Services Management
Software Management
Disk Management
System Monitoring
Summary
Chapter 4 SQL Server Configuration
The mssql-conf Utility
Using Variables
Linux Settings
Kernel Settings
Transparent Huge Pages
Swap File
Last Accessed Date/Time
SQL Server Configuration
Linux Out-of-Memory Killer
tempdb Configuration
Process Affinity
Max Degree of Parallelism
Cost Threshold for Parallelism
Statistics
Trace Flag 2371
Summary
Chapter 5 SQL Server Query Tuning and Optimization
Query Performance
Query Processor Architecture
Parsing and Binding
Query Optimization
Generating Candidate Execution Plans
Assessing the Cost of Each Plan
Query Execution and Plan Caching
Execution Plans
Graphical Plans
XML Plans
Text Plans
Query Troubleshooting
sys.dm_exec_requests and sys.dm_exec_sessions
sys.dm_exec_query_stats
statement_start_offset and statement_end_offset
sql_handle and plan_handle
query_hash and plan_hash
Finding Expensive Queries
SET STATISTICS TIME / IO
Indexes
Creating Indexes
Clustered Indexes vs. Heaps
Clustered Index Key
Statistics
Creating and Updating Statistics
The New Cardinality Estimator
Cardinality Estimation Errors
Statistics Maintenance
Parameter Sniffing
Optimizing for a Typical Parameter
Optimizing on Every Execution
Using Local Variables and the OPTIMIZE FOR UNKNOWN Hint
Disabling Parameter Sniffing
Query Processor Limitations
Query Optimization Research
Break Down Complex Queries
Hints
Summary
Chapter 6 New Query Processing Features
Adaptive Query Processing
Batch Mode Adaptive Joins
Batch Mode Adaptive Memory Grant Feedback
Interleaved Execution for Multistatement Table-Value Functions
Automatic Tuning
SQL Server 2016 Service Pack 1
Excerpt
Loading Excerpt...
Author Notes
Loading Author Notes...
Reviews from GoodReads
Loading GoodReads Reviews.
Staff View
Loading Staff View.