sql server performance -移花宫 -武林禁地，闲人禁止入内

Pluralsight - What Every Developer Should Know About SQL Server Performance

001 - Getting Started - Course Introduction.mp4 5.6 MB
002 - Getting Started - Why Application Developers Should Understand SQL Performance.mp4 2.9 MB
003 - Getting Started - What You Will Learn.mp4 2.7 MB
004 - Getting Started - What Tools You Need.mp4 5.2 MB
005 - Getting Started - Installing the Sample Database.mp4 6.8 MB
006 - Getting Started - Table Concepts.mp4 8.0 MB
007 - Getting Started - Index Concepts.mp4 6.0 MB
008 - Getting Started - Summary.mp4 1.7 MB
009 - Analyzing SQL Statements for Performance - Introduction.mp4 2.8 MB
010 - Analyzing SQL Statements for Performance - Understanding How SQL Server Will Execute a SQL Statement.mp4 10.6 MB
011 - Analyzing SQL Statements for Performance - Reading and Interpreting an Execution Plan for a SQL Statement.mp4 32.7 MB
012 - Analyzing SQL Statements for Performance - Getting Execution Statistics for a SQL Statement.mp4 12.7 MB
013 - Analyzing SQL Statements for Performance - Improving Statement Performance by Adding an Index.mp4 15.5 MB
014 - Analyzing SQL Statements for Performance - Before and After Performance Comparison.mp4 2.9 MB
015 - Analyzing SQL Statements for Performance - Rewriting SQL Statements for Improved Performance.mp4 14.6 MB
016 - Analyzing SQL Statements for Performance - Common Execution Plan Operations.mp4 14.2 MB
017 - Analyzing SQL Statements for Performance - Summary.mp4 8.4 MB
018 - Building Effective Indexes - Introduction.mp4 2.1 MB
019 - Building Effective Indexes - Index Terminology Refresher.mp4 5.3 MB
020 - Building Effective Indexes - What Should I Index in My Database_.mp4 5.1 MB

[磁力链接] 添加时间:2017-02-11 大小:543.1 MB 最近下载:2025-03-12 热度:2961

SQL Server Performance Indexing Basics - Pluralsight

tracked_by_h33t_com.txt 185 Bytes
pluralsight_-_SQL_Server_Performance_-_Indexing_Basics.rar 245.6 MB
Torrent Downloaded From ExtraTorrent.com.txt 339 Bytes

[磁力链接] 添加时间:2017-02-13 大小:245.6 MB 最近下载:2025-03-08 热度:799

Advanced SQL Server Performance Tuning

08 Conclusion/001 Thank you Lets Wrap Up This Course..html 2.5 kB
01 Introduction/001 Content Warning. Please Dont Skip. Thanks..html 2.6 kB
01 Introduction/003 Section 1 Summary.html 1.8 kB
01 Introduction/002 Instructor Introduction..html 2.6 kB
01 Introduction/001 Whats In This Course.mp4 4.7 MB
07 Miscellaneous/001 Enable Auto Update Stats Async.html 4.1 kB
07 Miscellaneous/002 Section 7 Summary.html 1.8 kB
03 Caching Issues/004 Simple Parameterization.mp4 4.6 MB
03 Caching Issues/005 Parameter Sniffing Demonstration.mp4 33.6 MB
03 Caching Issues/006 Fixing Parameter Sniffing.mp4 33.0 MB
03 Caching Issues/007 Plan Guides Demonstration.mp4 11.0 MB
03 Caching Issues/003 Procedure Cache Architecture.mp4 9.0 MB
03 Caching Issues/001 What Are Plan Guides.html 2.1 kB
03 Caching Issues/002 Section 3 Summary.html 3.4 kB
03 Caching Issues/001 What is the Buffer Pool.mp4 3.6 MB
03 Caching Issues/002 High Level Structure of Procedure Cache.mp4 2.7 MB
04 Hints and Filters/004 Filtered Index With Massive Reduction In Logical Reads.mp4 14.5 MB
04 Hints and Filters/002 Filtered Indexes.mp4 21.4 MB
04 Hints and Filters/003 Filtered Indexes With Sparse Columns.mp4 6.3 MB
04 Hints and Filters/001 Section 4 Summary.html 2.8 kB

[磁力链接] 添加时间:2017-02-21 大小:387.4 MB 最近下载:2025-03-10 热度:2673

SQL Server Performance Tuning

SQL Server Performance Tuning.tgz 796.2 MB
Torrent downloaded from demonoid.pw.txt 46 Bytes
Torrent Downloaded From ExtraTorrent.cc.txt 352 Bytes

[磁力链接] 添加时间:2017-02-24 大小:796.2 MB 最近下载:2025-03-11 热度:1261

[pluralsight-training.net] SQL Server Performance - Indexing Basics

1. Introduction/01. Introduction.wmv 3.1 MB
2. Fundamentals of Indexing/01. Introduction.wmv 1.5 MB
2. Fundamentals of Indexing/02. Index Fundamentals.wmv 10.7 MB
2. Fundamentals of Indexing/03. Index Fundamentals - Visual Representation.wmv 6.5 MB
2. Fundamentals of Indexing/04. Demo.wmv 17.2 MB
2. Fundamentals of Indexing/05. Additional Information.wmv 3.3 MB
2. Fundamentals of Indexing/06. Summary.wmv 764.7 kB
3. Practical Indexing Implementation Techniques/01. Introduction.wmv 2.7 MB
3. Practical Indexing Implementation Techniques/02. Primary Key.wmv 1.8 MB
3. Practical Indexing Implementation Techniques/03. Demo - Primary Key.wmv 8.1 MB
3. Practical Indexing Implementation Techniques/04. Over Indexing.wmv 1.4 MB
3. Practical Indexing Implementation Techniques/05. Demo - Over Indexing.wmv 6.0 MB
3. Practical Indexing Implementation Techniques/06. Duplicate Index.wmv 1.2 MB
3. Practical Indexing Implementation Techniques/07. Demo - Duplicate Index.wmv 7.0 MB
3. Practical Indexing Implementation Techniques/08. Clustered Index.wmv 2.5 MB
3. Practical Indexing Implementation Techniques/09. Demo - Clustered Index.wmv 6.0 MB
3. Practical Indexing Implementation Techniques/10. Unique Index.wmv 932.1 kB
3. Practical Indexing Implementation Techniques/11. Demo - Unique Index.wmv 9.7 MB
3. Practical Indexing Implementation Techniques/12. Included Columns.wmv 1.7 MB
3. Practical Indexing Implementation Techniques/13. Demo - Included Columns.wmv 11.2 MB

[磁力链接] 添加时间:2017-03-04 大小:245.6 MB 最近下载:2025-03-10 热度:857

Pluralsight - SQL Server Performance Indexing Basics

1. Introduction/01. Introduction.wmv 3.1 MB
2. Fundamentals of Indexing/01. Introduction.wmv 1.5 MB
2. Fundamentals of Indexing/02. Index Fundamentals.wmv 10.7 MB
2. Fundamentals of Indexing/03. Index Fundamentals - Visual Representation.wmv 6.5 MB
2. Fundamentals of Indexing/04. Demo.wmv 17.2 MB
2. Fundamentals of Indexing/05. Additional Information.wmv 3.3 MB
2. Fundamentals of Indexing/06. Summary.wmv 764.7 kB
3. Practical Indexing Implementation Techniques/01. Introduction.wmv 2.7 MB
3. Practical Indexing Implementation Techniques/02. Primary Key.wmv 1.8 MB
3. Practical Indexing Implementation Techniques/03. Demo Primary Key.wmv 8.1 MB
3. Practical Indexing Implementation Techniques/04. Over Indexing.wmv 1.4 MB
3. Practical Indexing Implementation Techniques/05. Demo Over Indexing.wmv 6.0 MB
3. Practical Indexing Implementation Techniques/06. Duplicate Index.wmv 1.2 MB
3. Practical Indexing Implementation Techniques/07. Demo Duplicate Index.wmv 7.0 MB
3. Practical Indexing Implementation Techniques/08. Clustered Index.wmv 2.5 MB
3. Practical Indexing Implementation Techniques/09. Demo Clustered Index.wmv 6.0 MB
3. Practical Indexing Implementation Techniques/10. Unique Index.wmv 932.1 kB
3. Practical Indexing Implementation Techniques/11. Demo Unique Index.wmv 9.7 MB
3. Practical Indexing Implementation Techniques/12. Included Columns.wmv 1.7 MB
3. Practical Indexing Implementation Techniques/13. Demo Included Columns.wmv 11.2 MB

[磁力链接] 添加时间:2017-03-07 大小:245.6 MB 最近下载:2024-09-06 热度:146

Pluralsight - SQL Server Performance - Introduction to Query Tuning

05 - Performance Tuning Tools/05.08 - Demo - Performance Analysis of Logs (PAL) Tool.wmv 30.5 MB
05 - Performance Tuning Tools/05.03 - Demo - SSMS Performance Dashboard.wmv 28.1 MB
03 - Essential Indexing Techniques/03.06 - Demo - WHERE clause and ORDERs of Column.wmv 23.7 MB
04 - Query Design for Performance/04.03 - Demo - EXISTS vs IN vs JOIN.wmv 23.0 MB
05 - Performance Tuning Tools/05.10 - Demo - SQL Server Profiler.wmv 17.9 MB
04 - Query Design for Performance/04.09 - Demo - Plan Guide and Parameter Sniffing.wmv 17.3 MB
05 - Performance Tuning Tools/05.15 - Demo - Dynamic Management Views (DMV).wmv 16.7 MB
04 - Query Design for Performance/04.07 - Demo - Order of Table and Query Hints.wmv 16.4 MB
04 - Query Design for Performance/04.13 - Demo - UDFs, Views and Performance.wmv 16.4 MB
05 - Performance Tuning Tools/05.13 - Demo - SQL Server Wait Stats - CXPACKET.wmv 15.0 MB
02 - Execution Plan Basics/02.04 - Demo - Execution Plan Types.wmv 14.3 MB
02 - Execution Plan Basics/02.02 - Demo.wmv 14.2 MB
05 - Performance Tuning Tools/05.06 - Demo - Database Tuning Advisor.wmv 13.4 MB
03 - Essential Indexing Techniques/03.04 - Demo - Included Columns.wmv 12.8 MB
05 - Performance Tuning Tools/05.11 - Demo - SQL Server Extended Events.wmv 12.7 MB
05 - Performance Tuning Tools/05.07 - Demo - Perfmon Counters.wmv 12.5 MB
04 - Query Design for Performance/04.05 - Demo - Common Table Expression (CTE).wmv 11.9 MB
06 - Tips and Tricks/06.09 - Demo - Performance Tips and Tricks.wmv 11.9 MB
03 - Essential Indexing Techniques/03.05 - Demo - Seek vs Scan vs Lookup.wmv 11.8 MB
02 - Execution Plan Basics/02.13 - Demo - Types of Joins.wmv 11.4 MB

[磁力链接] 添加时间:2017-03-12 大小:564.7 MB 最近下载:2024-10-17 热度:385

[pluralsight-training.net] SQL Server Performance - Introduction to Query Tuning

1. Introduction/1. Introduction.wmv 4.6 MB
1. Introduction/2. Query Tuning.wmv 4.4 MB
1. Introduction/3. Demo.wmv 8.0 MB
2. Execution Plan Basics/1. Introduction.wmv 5.8 MB
2. Execution Plan Basics/10. Demo - Key Lookup.wmv 6.2 MB
2. Execution Plan Basics/11. Index Seek vs Index Scan.wmv 2.2 MB
2. Execution Plan Basics/12. Types of Joins.wmv 2.9 MB
2. Execution Plan Basics/13. Demo - Types of Joins.wmv 11.4 MB
2. Execution Plan Basics/14. Summary.wmv 1.8 MB
2. Execution Plan Basics/2. Demo.wmv 14.2 MB
2. Execution Plan Basics/3. Various Execution Plan Types.wmv 4.1 MB
2. Execution Plan Basics/4. Demo - Execution Plan Types.wmv 14.3 MB
2. Execution Plan Basics/5. Clustered Index.wmv 6.3 MB
2. Execution Plan Basics/6. Demo - Clustered Index.wmv 7.4 MB
2. Execution Plan Basics/7. Non-clustered Index.wmv 2.5 MB
2. Execution Plan Basics/8. Demo - Non-clustered Index.wmv 7.5 MB
2. Execution Plan Basics/9. Key Lookup.wmv 1.2 MB
3. Essential Indexing Techniques/1. Introduction.wmv 6.0 MB
3. Essential Indexing Techniques/2. Demo - Basics of Index.wmv 11.1 MB
3. Essential Indexing Techniques/3. Index Behaviors.wmv 1.5 MB

[磁力链接] 添加时间:2017-03-16 大小:564.7 MB 最近下载:2025-03-13 热度:2161

SQL Server Performance Tuning.tgz

SQL Server Performance Tuning.tgz 796.2 MB

[磁力链接] 添加时间:2017-03-20 大小:796.2 MB 最近下载:2024-11-17 热度:310

[pluralsight-training.net] SQL Server - Performance Troubleshooting Using Wait Statistics

1. Introduction/1. Introduction.wmv 2.6 MB
1. Introduction/2. Where to Start Troubleshooting.wmv 2.9 MB
1. Introduction/3. Doctor, Doctor... My Knee Hurts!.wmv 3.2 MB
1. Introduction/4. Is the Symptom the Root Cause.wmv 3.8 MB
1. Introduction/5. Interpreting the Data.wmv 3.7 MB
1. Introduction/6. Demo - Explaining the Workload Mechanism.wmv 6.5 MB
1. Introduction/7. Course Structure.wmv 2.0 MB
2. SQL Server Threading Model/1. Introduction.wmv 2.0 MB
2. SQL Server Threading Model/10. Thread States.wmv 2.0 MB
2. SQL Server Threading Model/11. Transition from RUNNING to SUSPENDED.wmv 1.3 MB
2. SQL Server Threading Model/12. The Waiter List.wmv 2.1 MB
2. SQL Server Threading Model/13. Special Case - Quantum Exhaustion.wmv 2.5 MB
2. SQL Server Threading Model/14. Transition from SUSPENDED to RUNNABLE.wmv 2.0 MB
2. SQL Server Threading Model/15. The Runnable Queue.wmv 2.2 MB
2. SQL Server Threading Model/16. Special Case - Resource Governor.wmv 3.5 MB
2. SQL Server Threading Model/17. Resource Governor Example.wmv 2.8 MB
2. SQL Server Threading Model/18. Transition from RUNNABLE to RUNNING.wmv 1.1 MB
2. SQL Server Threading Model/19. Putting It All Together.wmv 2.1 MB
2. SQL Server Threading Model/2. What are Threads.wmv 3.1 MB
2. SQL Server Threading Model/20. Demo - Examining Threads on Schedulers.wmv 8.0 MB

[磁力链接] 添加时间:2017-03-23 大小:512.5 MB 最近下载:2025-03-13 热度:1552

What Every Developer Should Know About SQL Server Performance

06.Applying Common Performance Practices/01.Introduction.mp4 1.7 MB
01.Getting Started/08.Summary.mp4 1.9 MB
04.Finding Performance Bottlenecks in SQL Server/08.Summary.mp4 2.0 MB
03.Building Effective Indexes/01.Introduction.mp4 2.4 MB
02.Analyzing SQL Statements for Performance/01.Introduction.mp4 3.0 MB
01.Getting Started/03.What You Will Learn.mp4 3.0 MB
01.Getting Started/02.Why Application Developers Should Understand SQL Performance.mp4 3.4 MB
02.Analyzing SQL Statements for Performance/06.Before and After Performance Comparison.mp4 3.4 MB
06.Applying Common Performance Practices/07.Summary.mp4 3.8 MB
05.Capturing What Your Application is Doing Inside SQL Server/07.Running an Extended Events Trace Session.mp4 4.7 MB
05.Capturing What Your Application is Doing Inside SQL Server/05.Introduction to Using Extended Events for SQL Tracing.mp4 4.7 MB
03.Building Effective Indexes/06.Index Selectivity Explained.mp4 4.8 MB
04.Finding Performance Bottlenecks in SQL Server/02.Required Permissions for Querying Dynamic Management Views.mp4 4.8 MB
06.Applying Common Performance Practices/05.Object Relational Mappers Just Generate SQL.mp4 4.9 MB
03.Building Effective Indexes/05.Applying Index Column Order Rules.mp4 5.0 MB
06.Applying Common Performance Practices/03.Are Stored Procedures Faster Than SQL in Application Code.mp4 5.5 MB
03.Building Effective Indexes/03.What Should I Index in My Database.mp4 5.8 MB
01.Getting Started/04.What Tools You Need.mp4 6.2 MB
03.Building Effective Indexes/02.Index Terminology Refresher.mp4 6.3 MB
01.Getting Started/01.Course Introduction.mp4 6.4 MB

[磁力链接] 添加时间:2017-04-30 大小:671.8 MB 最近下载:2025-03-01 热度:693

Pluralsight - SQL Server Performance - Indexing Basics

06 - Indexing Practical Performance Tips and Tricks/06.09 - Index and Order of Columns.wmv 18.7 MB
02 - Fundamentals of Indexing/02.04 - Demo.wmv 17.2 MB
04 - Index Maintenance/04.02 - Demo - Index Maintenance .wmv 15.9 MB
07 - Checklist - Index and Performance/07.01 - Final Checklist.wmv 12.3 MB
03 - Practical Indexing Implementation Techniques/03.13 - Demo - Included Columns.wmv 11.2 MB
04 - Index Maintenance/04.04 - Demo - Defragmentation.wmv 10.8 MB
02 - Fundamentals of Indexing/02.02 - Index Fundamentals.wmv 10.7 MB
03 - Practical Indexing Implementation Techniques/03.15 - Demo - Filtered Index.wmv 10.5 MB
03 - Practical Indexing Implementation Techniques/03.17 - Demo - Disabled Index.wmv 9.8 MB
03 - Practical Indexing Implementation Techniques/03.11 - Demo - Unique Index.wmv 9.7 MB
06 - Indexing Practical Performance Tips and Tricks/06.06 - Index and Functions.wmv 8.2 MB
03 - Practical Indexing Implementation Techniques/03.03 - Demo - Primary Key.wmv 8.1 MB
05 - Introduction to Columnstore Index/05.03 - Demo.wmv 7.7 MB
03 - Practical Indexing Implementation Techniques/03.07 - Demo - Duplicate Index.wmv 7.0 MB
06 - Indexing Practical Performance Tips and Tricks/06.05 - Effect of Compression and Fillfactor.wmv 6.8 MB
02 - Fundamentals of Indexing/02.03 - Index Fundamentals - Visual Representation.wmv 6.5 MB
06 - Indexing Practical Performance Tips and Tricks/06.08 - Table Scan, Index Scan and Index Seek.wmv 6.5 MB
03 - Practical Indexing Implementation Techniques/03.09 - Demo - Clustered Index.wmv 6.0 MB
03 - Practical Indexing Implementation Techniques/03.05 - Demo - Over Indexing.wmv 6.0 MB
05 - Introduction to Columnstore Index/05.02 - Concepts.wmv 3.7 MB

[磁力链接] 添加时间:2017-06-08 大小:245.6 MB 最近下载:2024-10-14 热度:578

Pluralsight - SQL Server Performance - Indexing Basics

06 - Indexing Practical Performance Tips and Tricks/06.09 - Index and Order of Columns.wmv 18.7 MB
02 - Fundamentals of Indexing/02.04 - Demo.wmv 17.2 MB
04 - Index Maintenance/04.02 - Demo - Index Maintenance .wmv 15.9 MB
07 - Checklist - Index and Performance/07.01 - Final Checklist.wmv 12.3 MB
03 - Practical Indexing Implementation Techniques/03.13 - Demo - Included Columns.wmv 11.2 MB
04 - Index Maintenance/04.04 - Demo - Defragmentation.wmv 10.8 MB
02 - Fundamentals of Indexing/02.02 - Index Fundamentals.wmv 10.7 MB
03 - Practical Indexing Implementation Techniques/03.15 - Demo - Filtered Index.wmv 10.5 MB
03 - Practical Indexing Implementation Techniques/03.17 - Demo - Disabled Index.wmv 9.8 MB
03 - Practical Indexing Implementation Techniques/03.11 - Demo - Unique Index.wmv 9.7 MB
06 - Indexing Practical Performance Tips and Tricks/06.06 - Index and Functions.wmv 8.2 MB
03 - Practical Indexing Implementation Techniques/03.03 - Demo - Primary Key.wmv 8.1 MB
05 - Introduction to Columnstore Index/05.03 - Demo.wmv 7.7 MB
03 - Practical Indexing Implementation Techniques/03.07 - Demo - Duplicate Index.wmv 7.0 MB
06 - Indexing Practical Performance Tips and Tricks/06.05 - Effect of Compression and Fillfactor.wmv 6.8 MB
02 - Fundamentals of Indexing/02.03 - Index Fundamentals - Visual Representation.wmv 6.5 MB
06 - Indexing Practical Performance Tips and Tricks/06.08 - Table Scan, Index Scan and Index Seek.wmv 6.5 MB
03 - Practical Indexing Implementation Techniques/03.09 - Demo - Clustered Index.wmv 6.0 MB
03 - Practical Indexing Implementation Techniques/03.05 - Demo - Over Indexing.wmv 6.0 MB
05 - Introduction to Columnstore Index/05.02 - Concepts.wmv 3.7 MB

[磁力链接] 添加时间:2018-02-19 大小:245.6 MB 最近下载:2025-01-11 热度:70

Lynda - SQL Server Performance for Developers

6.5. Indexing/28.Overview of nonclustered indexes.mp4 19.0 MB
1.Introduction/01.Welcome.mp4 4.6 MB
1.Introduction/02.What you should know.en.srt 5.9 kB
1.Introduction/02.What you should know.mp4 5.0 MB
2.1. Query Execution/03.Execution plans introduction.en.srt 9.4 kB
2.1. Query Execution/03.Execution plans introduction.mp4 7.8 MB
2.1. Query Execution/04.How to read an execution plan.en.srt 11.9 kB
2.1. Query Execution/04.How to read an execution plan.mp4 11.8 MB
2.1. Query Execution/05.Execution plan XMLs.en.srt 5.2 kB
2.1. Query Execution/05.Execution plan XMLs.mp4 9.1 MB
2.1. Query Execution/06.Key lookup - When it's good and when it's bad.en.srt 8.0 kB
2.1. Query Execution/06.Key lookup - When it's good and when it's bad.mp4 8.4 MB
2.1. Query Execution/07.Nested loop vs. hash join.en.srt 9.2 kB
2.1. Query Execution/07.Nested loop vs. hash join.mp4 9.5 MB
2.1. Query Execution/08.Query Store.en.srt 15.6 kB
2.1. Query Execution/08.Query Store.mp4 16.6 MB
2.1. Query Execution/09.Stored procedures vs. dynamic SQL.en.srt 10.3 kB
2.1. Query Execution/09.Stored procedures vs. dynamic SQL.mp4 10.7 MB
2.1. Query Execution/10.Missing index warnings.en.srt 11.8 kB
2.1. Query Execution/10.Missing index warnings.mp4 12.7 MB

[磁力链接] 添加时间:2018-06-28 大小:446.8 MB 最近下载:2025-03-13 热度:2680

[ FreeCourseWeb.com ] PluralSight - Troubleshooting SQL Server Performance Problems.zip

[ FreeCourseWeb.com ] PluralSight - Troubleshooting SQL Server Performance Problems.zip 259.9 MB

[磁力链接] 添加时间:2021-03-23 大小:259.9 MB 最近下载:2025-03-12 热度:668

[ FreeCourseWeb.com ] Udemy - Building an Automated SQL Server Performance Tuning Engine.zip

[ FreeCourseWeb.com ] Udemy - Building an Automated SQL Server Performance Tuning Engine.zip 154.2 MB

[磁力链接] 添加时间:2021-04-06 大小:154.2 MB 最近下载:2025-03-06 热度:953

Udemy - SQL Server Performance Tuning e Analisi Piani di Esecuzione (Update 01 2024) [Ita]

2. Indici e piani d'esecuzione di SQL Server/4.1 005_algoritmi_di_join.mov 249.7 MB
7. Approfondimenti sulle performance di SQL Server/2. Warning nei piani d'esecuzione e approfondimento sulle statistiche.mp4 192.1 MB
7. Approfondimenti sulle performance di SQL Server/1. Cercare proattivamente le query più problematiche.mp4 170.6 MB
2. Indici e piani d'esecuzione di SQL Server/8. Sperimentiamo come cambia il QEP di quattro query al variare degli indici.mp4 144.5 MB
2. Indici e piani d'esecuzione di SQL Server/5. Covered index e indici multi-colonna.mp4 141.1 MB
3. Ottimizzazione query con T-SQL/8. Approfondimento T-SQL Window Function.mp4 133.5 MB
4. Esercizi sul tuning delle query/3. Tuning con tabelle temporanee e SQL dinamico.mp4 128.2 MB
5. T-SQL Avanzato/5. Approfondimento Grouping sets - rollup - cube.mp4 125.6 MB
5. T-SQL Avanzato/6. Approfondimento Pivot e Unpivot dei dati.mp4 118.9 MB
6. Machine Learning con T-SQL/3. Implementazione dell'algoritmo del Perceptron.mp4 117.6 MB
2. Indici e piani d'esecuzione di SQL Server/6. Importanza dell'ordine delle colonne in un clustered index.mp4 114.8 MB
2. Indici e piani d'esecuzione di SQL Server/2. Fattori che influenzano l'utilizzo di un indice non clustered.mp4 113.4 MB
2. Indici e piani d'esecuzione di SQL Server/1. Chiavi primarie, indici clustered e indici non clustered.mp4 113.0 MB
2. Indici e piani d'esecuzione di SQL Server/3. Operazioni di ordinamento e rimozioni duplicati.mp4 101.1 MB
3. Ottimizzazione query con T-SQL/10. Analisi delle performance delle Window function - esempio 1.mp4 101.0 MB
6. Machine Learning con T-SQL/1. Introduzione al Machine Learning e al pre-processing dei dati.mp4 100.6 MB
3. Ottimizzazione query con T-SQL/9. Approfondimento Window function per somme cumulate, lead, lag e ntile.mp4 96.0 MB
2. Indici e piani d'esecuzione di SQL Server/4. Algoritmi di join.mp4 92.5 MB
5. T-SQL Avanzato/2. Transazioni e gestione degli errori - parte 2.mp4 91.1 MB
5. T-SQL Avanzato/3. Transazioni e gestione degli errori - parte 3.mp4 87.3 MB

[磁力链接] 添加时间:2024-03-13 大小:3.8 GB 最近下载:2025-03-14 热度:4053

[ FreeCourseWeb.com ] CloudAcademy - Azure SQL and SQL Server Query Performance Tuning.zip

[ FreeCourseWeb.com ] CloudAcademy - Azure SQL and SQL Server Query Performance Tuning.zip 1.8 GB

[磁力链接] 添加时间:2021-03-07 大小:1.8 GB 最近下载:2025-03-13 热度:1863

Pluralsight - SQL Server Optimizing Stored Procedure Performance

01 Introduction/0101 Introduction.mp4 5.3 MB
01 Introduction/0102 This Course.mp4 4.9 MB
01 Introduction/0103 What Does Optimizing Stored Procedure Performance Mean.mp4 6.0 MB
01 Introduction/0104 Does This Sound Familiar.mp4 4.4 MB
01 Introduction/0105 What Does Optimizing Stored Procedure Performance NOT Mean.mp4 7.3 MB
01 Introduction/0106 Why This Course Is Relevant.mp4 5.8 MB
01 Introduction/0107 Course Focus and Structure (1).mp4 4.2 MB
01 Introduction/0108 Course Focus and Structure (2).mp4 4.7 MB
02 Why Use Stored Procedures/0201 Overview.mp4 3.2 MB
02 Why Use Stored Procedures/0202 Different Ways to Execute SQL Statements.mp4 5.0 MB
02 Why Use Stored Procedures/0203 Some Statements Can Be Cached for Reuse (1).mp4 3.9 MB
02 Why Use Stored Procedures/0204 Some Statements Can Be Cached for Reuse (2).mp4 8.1 MB
02 Why Use Stored Procedures/0205 Version-Specific Plan Caching Whitepapers.mp4 2.3 MB
02 Why Use Stored Procedures/0206 Reducing Plan Cache Pollution.mp4 9.3 MB
02 Why Use Stored Procedures/0207 Understanding sp_executesql.mp4 5.7 MB
02 Why Use Stored Procedures/0208 Stored Procedures sp_executesql and the Cache.mp4 5.5 MB
02 Why Use Stored Procedures/0209 Parameter Sniffing.mp4 4.0 MB
02 Why Use Stored Procedures/0210 Summary Why Use Stored Procedures.mp4 6.9 MB
03 Creation, Compilation, and Invalidation Section 1/0301 Overview.mp4 3.6 MB
03 Creation, Compilation, and Invalidation Section 1/0302 What Happens When You Create a Procedure.mp4 6.3 MB

[磁力链接] 添加时间:2017-02-10 大小:1.9 GB 最近下载:2025-03-14 热度:3682

SQL Server Optimizing Ad Hoc Statement Performance

05. Plan Cache Pollution/06. Demo Analyzing for Plan Cache Pollution.wmv 61.5 MB
04. Statement Caching/15. Demo Part 2 - The Right Way to Force Statements.wmv 39.5 MB
04. Statement Caching/07. Demo Ad Hoc Statements and the Plan Cache.wmv 39.1 MB
04. Statement Caching/10. Demo query_hash and query_plan_hash.wmv 37.0 MB
03. Estimates and Selectivity/15. Demo Reading the Histogram.wmv 34.2 MB
05. Plan Cache Pollution/09. Demo Part 1b - Covering to Make a Query Safe.wmv 32.8 MB
05. Plan Cache Pollution/08. Demo Part 1a - Optimize for Adhoc Workloads.wmv 30.2 MB
02. Statement Execution Methods/13. Demo Part 5 - sp_executesql with Unsafe Statement.wmv 30.1 MB
04. Statement Caching/14. Demo Part 1 - Making a Statement Safe with Covering.wmv 29.9 MB
03. Estimates and Selectivity/05. Demo Setup and First Look at Statistics.wmv 29.1 MB
03. Estimates and Selectivity/08. Demo When No Statistics Exist then Heuristics are Used.wmv 28.5 MB
03. Estimates and Selectivity/06. Demo Updates and Estimates.wmv 28.4 MB
02. Statement Execution Methods/15. Demo Part 7 - Dynamic String Execution with Unsafe Statement.wmv 23.9 MB
02. Statement Execution Methods/09. Demo Part 1 - Ad Hoc Safe Statements.wmv 22.5 MB
05. Plan Cache Pollution/17. Demo Part 3 - Clearing Single-Use Plan Cache Pollution.wmv 22.4 MB
02. Statement Execution Methods/10. Demo Part 2 - Ad Hoc Unsafe Statements.wmv 20.8 MB
05. Plan Cache Pollution/15. Demo Part 2c - Optimizing an Expensive Statement.wmv 20.7 MB
02. Statement Execution Methods/14. Demo Part 6 - Dynamic String Execution with Safe Statement.wmv 19.0 MB
05. Plan Cache Pollution/14. Demo Part 2b - Forcing a Stable Statement with a Plan Guide.wmv 18.9 MB
02. Statement Execution Methods/08. Demo Setting Up For Analyzing Cache.wmv 18.5 MB

[磁力链接] 添加时间:2017-02-10 大小:1.0 GB 最近下载:2025-03-14 热度:2480