![]() |
|
What Every Developer Should Know About SQL Server Performance - Printable Version +- Softwarez.Info - Software's World! (https://softwarez.info) +-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone) +--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials) +--- Thread: What Every Developer Should Know About SQL Server Performance (/Thread-What-Every-Developer-Should-Know-About-SQL-Server-Performance) |
What Every Developer Should Know About SQL Server Performance - AD-TEAM - 12-25-2024 ![]() 511.47 MB | 00:08:43 | mp4 | 1024X768 | 4:3 Genre:eLearning |Language:English
Files Included :
001 - Getting Started - Course Introduction.mp4 (5.3 MB) 002 - Getting Started - Why Application Developers Should Understand SQL Performance.mp4 (2.76 MB) 003 - Getting Started - What You Will Learn.mp4 (2.58 MB) 004 - Getting Started - What Tools You Need.mp4 (4.91 MB) 005 - Getting Started - Installing the Sample Database.mp4 (6.48 MB) 006 - Getting Started - Table Concepts.mp4 (7.67 MB) 007 - Getting Started - Index Concepts.mp4 (5.74 MB) 008 - Getting Started - Summary.mp4 (1.59 MB) 009 - Analyzing SQL Statements for Performance - Introduction.mp4 (2.62 MB) 010 - Analyzing SQL Statements for Performance - Understanding How SQL Server Will Execute a SQL Statement.mp4 (10.1 MB) 011 - Analyzing SQL Statements for Performance - Reading and Interpreting an Execution Plan for a SQL Statement.mp4 (31.17 MB) 012 - Analyzing SQL Statements for Performance - Getting Execution Statistics for a SQL Statement.mp4 (12.11 MB) 013 - Analyzing SQL Statements for Performance - Improving Statement Performance by Adding an Index.mp4 (14.76 MB) 014 - Analyzing SQL Statements for Performance - Before and After Performance Comparison.mp4 (2.76 MB) 015 - Analyzing SQL Statements for Performance - Rewriting SQL Statements for Improved Performance.mp4 (13.93 MB) 016 - Analyzing SQL Statements for Performance - Common Execution Plan Operations.mp4 (13.52 MB) 017 - Analyzing SQL Statements for Performance - Summary.mp4 (8 MB) 018 - Building Effective Indexes - Introduction.mp4 (2.04 MB) 019 - Building Effective Indexes - Index Terminology Refresher.mp4 (5.04 MB) 020 - Building Effective Indexes - What Should I Index in My Database.mp4 (4.9 MB) 021 - Building Effective Indexes - Why Index Column Order Matters.mp4 (12.02 MB) 022 - Building Effective Indexes - Applying Index Column Order Rules.mp4 (4.06 MB) 023 - Building Effective Indexes - Index Selectivity Explained.mp4 (3.91 MB) 024 - Building Effective Indexes - Index Selectivity Examples.mp4 (22.95 MB) 025 - Building Effective Indexes - LIKE Clauses and Index Selectivity.mp4 (9.51 MB) 026 - Building Effective Indexes - How Functions in the WHERE Clause Affect Indexes.mp4 (13.57 MB) 027 - Building Effective Indexes - Include Columns and Covering Indexes.mp4 (9 MB) 028 - Building Effective Indexes - Over-indexing.mp4 (6.39 MB) 029 - Building Effective Indexes - Interpreting SQL Server Index Recommendations.mp4 (5.42 MB) 030 - Building Effective Indexes - Module Review.mp4 (9.03 MB) 031 - Finding Performance Bottlenecks in SQL Server - Introduction.mp4 (5.61 MB) 032 - Finding Performance Bottlenecks in SQL Server - Required Permissions for Querying Dynamic Management Views.mp4 (3.73 MB) 033 - Finding Performance Bottlenecks in SQL Server - Getting Information About SQL Server Sessions and Resource Usage.mp4 (10.29 MB) 034 - Finding Performance Bottlenecks in SQL Server - Finding What SQL Statements are Currently Executing.mp4 (16.08 MB) 035 - Finding Performance Bottlenecks in SQL Server - Finding the Slowest, Most Expensive SQL Statements.mp4 (15.05 MB) 036 - Finding Performance Bottlenecks in SQL Server - Getting SQL Server's Recommendations on Missing Indexes.mp4 (16.48 MB) 037 - Finding Performance Bottlenecks in SQL Server - Finding Indexes That are Not Being Used.mp4 (13.69 MB) 038 - Finding Performance Bottlenecks in SQL Server - Summary.mp4 (1.7 MB) 039 - Capturing What Your Application is Doing Inside SQL Server - What is SQL Tracing and Why Developers Should Know About it.mp4 (6.44 MB) 040 - Capturing What Your Application is Doing Inside SQL Server - Setting up a SQL Profiler Trace.mp4 (14.01 MB) 041 - Capturing What Your Application is Doing Inside SQL Server - Running a SQL Profiler Trace.mp4 (15.29 MB) 042 - Capturing What Your Application is Doing Inside SQL Server - Running a Trace as a Server Side Trace.mp4 (20.7 MB) 043 - Capturing What Your Application is Doing Inside SQL Server - Introduction to Using Extended Events for SQL Tracing.mp4 (3.9 MB) 044 - Capturing What Your Application is Doing Inside SQL Server - Setting up an Extended Events Trace Session.mp4 (23.55 MB) 045 - Capturing What Your Application is Doing Inside SQL Server - Running an Extended Events Trace Session.mp4 (3.74 MB) 046 - Capturing What Your Application is Doing Inside SQL Server - Configuring the Display Settings for Extended Events Data.mp4 (6.63 MB) 047 - Capturing What Your Application is Doing Inside SQL Server - Analyzing Extended Events Trace Data.mp4 (16.57 MB) 048 - Capturing What Your Application is Doing Inside SQL Server - Using Extended Events in SQL Azure.mp4 (11.25 MB) 049 - Capturing What Your Application is Doing Inside SQL Server - Summary.mp4 (9.17 MB) 050 - Applying Common Performance Practices - Introduction.mp4 (1.71 MB) 051 - Applying Common Performance Practices - Use Parameterized SQL.mp4 (9.5 MB) 052 - Applying Common Performance Practices - Are Stored Procedures Faster Than SQL in Application Code.mp4 (4.42 MB) 053 - Applying Common Performance Practices - Commit Behavior and Performance.mp4 (7.58 MB) 054 - Applying Common Performance Practices - Object Relational Mappers Just Generate SQL.mp4 (3.94 MB) 055 - Applying Common Performance Practices - Solving the N+1 Selects Problem.mp4 (13.73 MB) 056 - Applying Common Performance Practices - Summary.mp4 (3.17 MB) sql-server-performance-every-developer-should-know.zip (6.13 MB)] Screenshot ![]() |