Скачать SQL Server: Index Fragmentation Internals, Analysis, and Solutions (ENG) (2015) торрент

717 0
Обратите внимание на эти раздачи:
SQL Server: Index Fragmentation Internals, Analysis, and Solutions (ENG) (2015)

SQL Server: Index Fragmentation Internals, Analysis, and Solutions (ENG) (2015)

Информация:

Год выпуска: 2015
Производитель: Pluralsight
Автор: Jonathan Kehayias
Продолжительность: 2h 39m
Тип раздаваемого материала: Видеоклипы
Язык: Английский

Файлы примеров: отсутствуют
Формат видео: WMV
Видео: wmv3, 15 fps, 1024x768, 89~3618kbps
Аудио: wma2, 128kbps, 44.1kHz, Stereo



Описание:

Learn how to properly configure and control essential SQL Server database maintenance using Maintenance Plans.
This course is applicable to anyone responsible for SQL Server databases, with any level of SQL Server experience.
Proper database maintenance is critical for making sure that database workloads perform as well as possible.
One of the simplest ways to implement database maintenance is to use the built-in Maintenance Plan functionality to schedule the critical database maintenance tasks - backups, consistency checking, statistics maintenance and index maintenance.
The course starts by explaining how to configure Database Mail, and Operator, and alerts, all within SQL Server Agent.
It then describes all the commonly-required maintenance tasks and shows how to configure them, along with do's and don'ts, plus some of the less commonly used tasks.
After that it shows how to pull these tasks together into Maintenance Plans using the Maintenance Plan Wizard, the Maintenance Plan Designer, and through Integration Services packages.
Finally the course discusses some of the alternative methods of implementing database maintenance through freely-available scripts.
This course is perfect for anyone who is responsible for SQL Server databases, with any level of experience, from SQL Server 2005 onward. Содержание FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Introduction 1.97 MB 0:01:15 ‎128kbps 135.00 1024x768 ‎15 frames/second 01.Introduction
02.Course Expectations 2.27 MB 0:01:25 ‎128kbps 191.00 1024x768 ‎15 frames/second 01.Introduction
03.Course Structure 1.00 MB 0:00:42 ‎128kbps 89.00 1024x768 ‎15 frames/second 01.Introduction
01.Introduction 1.41 MB 0:00:55 ‎128kbps 146.00 1024x768 ‎15 frames/second 02.Approaches to Database Maintenance
02.Core Maintenance Tasks 4.42 MB 0:02:50 ‎128kbps 210.00 1024x768 ‎15 frames/second 02.Approaches to Database Maintenance
03.Database Maintenance Plans 3.28 MB 0:02:10 ‎128kbps 169.00 1024x768 ‎15 frames/second 02.Approaches to Database Maintenance
04.SSIS Packages 3.43 MB 0:02:19 ‎128kbps 192.00 1024x768 ‎15 frames/second 02.Approaches to Database Maintenance
05.Custom Transact-SQL Scripts 3.83 MB 0:02:33 ‎128kbps 184.00 1024x768 ‎15 frames/second 02.Approaches to Database Maintenance
06.PowerShell Scripts 2.05 MB 0:01:26 ‎128kbps 99.00 1024x768 ‎15 frames/second 02.Approaches to Database Maintenance
07.Summary 1.24 MB 0:00:50 ‎128kbps 119.00 1024x768 ‎15 frames/second 02.Approaches to Database Maintenance
01.Introduction 2.28 MB 0:01:28 ‎128kbps 149.00 1024x768 ‎15 frames/second 03.Configuring SQL Server Agent Settings
02.Configuring Database Mail 1.96 MB 0:01:20 ‎128kbps 150.00 1024x768 ‎15 frames/second 03.Configuring SQL Server Agent Settings
03.Demo - Configuring Database Mail 10.9 MB 0:06:18 ‎128kbps 352.00 1024x768 ‎15 frames/second 03.Configuring SQL Server Agent Settings
04.Demo - Viewing-Modifying Database Mail Settings 2.51 MB 0:01:30 ‎128kbps 219.00 1024x768 ‎15 frames/second 03.Configuring SQL Server Agent Settings
05.Configuring SQL Server Agent Mail Settings 2.63 MB 0:01:42 ‎128kbps 209.00 1024x768 ‎15 frames/second 03.Configuring SQL Server Agent Settings
06.Demo - SQL Server Agent Mail Settings 5.06 MB 0:03:15 ‎128kbps 189.00 1024x768 ‎15 frames/second 03.Configuring SQL Server Agent Settings
07.Configuring SQL Server Agent History Retention 2.81 MB 0:01:53 ‎128kbps 172.00 1024x768 ‎15 frames/second 03.Configuring SQL Server Agent Settings
08.Demo - Configuring SQL Server Agent History Retention 2.91 MB 0:01:50 ‎128kbps 179.00 1024x768 ‎15 frames/second 03.Configuring SQL Server Agent Settings
09.Demo - Managing Retention History with a Job 5.33 MB 0:03:19 ‎128kbps 186.00 1024x768 ‎15 frames/second 03.Configuring SQL Server Agent Settings
10.Creating SQL Server Agent Alerts 2.05 MB 0:01:24 ‎128kbps 109.00 1024x768 ‎15 frames/second 03.Configuring SQL Server Agent Settings
11.Demo - Creating SQL Server Agent Alerts 4.65 MB 0:02:36 ‎128kbps 268.00 1024x768 ‎15 frames/second 03.Configuring SQL Server Agent Settings
12.Summary 2.02 MB 0:01:22 ‎128kbps 144.00 1024x768 ‎15 frames/second 03.Configuring SQL Server Agent Settings
01.Introduction 1.65 MB 0:01:05 ‎128kbps 127.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
02.Maintenance Plan Considerations 3.97 MB 0:02:44 ‎128kbps 152.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
03.Back Up Database Task (Full) 3.18 MB 0:02:11 ‎128kbps 160.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
04.Back Up Database Task (Transaction Log) 3.66 MB 0:02:25 ‎128kbps 215.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
05.Back Up Database Task (Differential) 3.28 MB 0:02:09 ‎128kbps 174.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
06.Demo - Back Up Database Task Configuration 5.63 MB 0:03:32 ‎128kbps 161.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
07.Check Database Integrity Task 2.24 MB 0:01:28 ‎128kbps 191.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
08.DBCC CHECKDB Options 3.87 MB 0:02:23 ‎128kbps 246.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
09.Dealing with Corruption 2.96 MB 0:01:55 ‎128kbps 215.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
10.Demo - Check Database Integrity Task 2.42 MB 0:01:29 ‎128kbps 148.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
11.Rebuild Index Task 3.24 MB 0:02:10 ‎128kbps 158.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
12.Rebuild Index Task (2) 3.22 MB 0:02:06 ‎128kbps 194.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
13.Demo - Rebuild Index Task 5.01 MB 0:03:04 ‎128kbps 160.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
14.Reorganize Index Task 2.80 MB 0:01:55 ‎128kbps 149.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
15.Demo - Reorganize Index Task 3.02 MB 0:01:48 ‎128kbps 147.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
16.Update Statistics Task 4.47 MB 0:02:51 ‎128kbps 206.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
17.Demo - Update Statistics Task 3.01 MB 0:01:56 ‎128kbps 144.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
18.History Cleanup Task 2.21 MB 0:01:31 ‎128kbps 137.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
19.Demo - History Cleanup Task 3.36 MB 0:02:07 ‎128kbps 135.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
20.Maintenance Cleanup Task 1.90 MB 0:01:19 ‎128kbps 122.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
21.Demo - Maintenance Cleanup Task 5.08 MB 0:03:20 ‎128kbps 138.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
22.Summary 2.08 MB 0:01:23 ‎128kbps 165.00 1024x768 ‎15 frames/second 04.Common Maintenance Tasks
01.Introduction 1.66 MB 0:01:05 ‎128kbps 120.00 1024x768 ‎15 frames/second 05.Other Tasks
02.Shrink Database Task 4.03 MB 0:02:39 ‎128kbps 195.00 1024x768 ‎15 frames/second 05.Other Tasks
03.Demo - Shrink Database Task 3.94 MB 0:02:35 ‎128kbps 137.00 1024x768 ‎15 frames/second 05.Other Tasks
04.Execute SQL Server Agent Job Task 2.09 MB 0:01:29 ‎128kbps 113.00 1024x768 ‎15 frames/second 05.Other Tasks
05.Demo - Execute SQL Server Agent Job Task 2.71 MB 0:01:44 ‎128kbps 143.00 1024x768 ‎15 frames/second 05.Other Tasks
06.Execute T-SQL Statement Task 1.84 MB 0:01:16 ‎128kbps 171.00 1024x768 ‎15 frames/second 05.Other Tasks
07.Demo - Execute T-SQL Statement Task 2.08 MB 0:01:21 ‎128kbps 138.00 1024x768 ‎15 frames/second 05.Other Tasks
08.Notify Operator Task 2.25 MB 0:01:30 ‎128kbps 167.00 1024x768 ‎15 frames/second 05.Other Tasks
09.Demo - Notify Operator Task 3.09 MB 0:02:04 ‎128kbps 131.00 1024x768 ‎15 frames/second 05.Other Tasks
10.Summary 1.37 MB 0:00:58 ‎128kbps 113.00 1024x768 ‎15 frames/second 05.Other Tasks
01.Introduction 2.83 MB 0:01:47 ‎128kbps 192.00 1024x768 ‎15 frames/second 06.Creating Maintenance Plans
02.Maintenance Plan Wizard Introduction 3.50 MB 0:02:13 ‎128kbps 229.00 1024x768 ‎15 frames/second 06.Creating Maintenance Plans
03.Demo - Maintenance Plan Wizard 11.9 MB 0:06:31 ‎128kbps 311.00 1024x768 ‎15 frames/second 06.Creating Maintenance Plans
04.Maintenance Plan Designer Introduction 3.16 MB 0:02:00 ‎128kbps 218.00 1024x768 ‎15 frames/second 06.Creating Maintenance Plans
05.Demo - Maintenance Plan Designer 12.8 MB 0:06:43 ‎128kbps 268.00 1024x768 ‎15 frames/second 06.Creating Maintenance Plans
06.SQL Server Integration Services Packages 1.93 MB 0:01:18 ‎128kbps 143.00 1024x768 ‎15 frames/second 06.Creating Maintenance Plans
07.Demo - SSIS Packages 10.9 MB 0:05:53 ‎128kbps 280.00 1024x768 ‎15 frames/second 06.Creating Maintenance Plans
08.Options to Simplify Maintenance Plan Reuse 3.88 MB 0:02:27 ‎128kbps 205.00 1024x768 ‎15 frames/second 06.Creating Maintenance Plans
09.Summary 2.90 MB 0:01:55 ‎128kbps 159.00 1024x768 ‎15 frames/second 06.Creating Maintenance Plans
01.Introduction 1.72 MB 0:01:05 ‎128kbps 151.00 1024x768 ‎15 frames/second 07.Maintenance Plan Challenges and Alternatives
02.Index Maintenance Limitations 2.27 MB 0:01:28 ‎128kbps 164.00 1024x768 ‎15 frames/second 07.Maintenance Plan Challenges and Alternatives
03.Fragmentation-Based Analysis 2.19 MB 0:01:20 ‎128kbps 216.00 1024x768 ‎15 frames/second 07.Maintenance Plan Challenges and Alternatives
04.Michelle Ufford's Reindexing Script 3.48 MB 0:02:12 ‎128kbps 214.00 1024x768 ‎15 frames/second 07.Maintenance Plan Challenges and Alternatives
05.Demo - Michelle Uffords Reindex Script 25.2 MB 0:05:30 ‎128kbps 3618.00 1024x768 ‎15 frames/second 07.Maintenance Plan Challenges and Alternatives
06.Ola Hallengren's Maintenance Scripts 2.36 MB 0:01:36 ‎128kbps 181.00 1024x768 ‎15 frames/second 07.Maintenance Plan Challenges and Alternatives
07.Ola Hallengren's Maintenance Scripts (2) 2.59 MB 0:01:40 ‎128kbps 169.00 1024x768 ‎15 frames/second 07.Maintenance Plan Challenges and Alternatives
08.Demo - Ola Hallengren's Scripts 17.3 MB 0:05:04 ‎128kbps 1526.00 1024x768 ‎15 frames/second 07.Maintenance Plan Challenges and Alternatives
09.Summary 1.05 MB 0:00:40 ‎128kbps 116.00 1024x768 ‎15 frames/second 07.Maintenance Plan Challenges and Alternatives



magnet:?xt=urn:btih:FF75AE7DBD4894913B2C29B69D8A6256B1E1B01F
SQL Server: Index Fragmentation Internals, Analysis, and Solutions (ENG) (2015) 4.5 из 5 на основе 717 просмотров, 5 отзывов.

Если вы не видите кнопку СКАЧАТЬ - отключите резалку рекламы у себя в браузере и обновите страницу...

торрент SQL Server: Index Fragmentation Internals, Analysis, and Solutions (ENG) (2015)

277.71 MB
Pluralsight - SQL Server - Index Fragmentation Internals, Analysis, and Solutions (60 файлов)
01. Introduction (3 файла)
file 01_01-Introduction and Why Index Fragmentation Is Important.mp4 (4.25 MB)
file 01_02-Common Myths Around Index Fragmentation.mp4 (4.63 MB)
file 01_03-Course Structure and Module Summary.mp4 (2.65 MB)
02. Index Structure and Index Uses (9 файлов)
file 02_01-Introduction.mp4 (1.14 MB)
file 02_02-Index Structure.mp4 (3.57 MB)
file 02_03-Demo Index Structure.mp4 (9.23 MB)
file 02_04-Singleton Lookup.mp4 (2.46 MB)
file 02_05-Scan.mp4 (2.75 MB)
file 02_06-Allocation Order Scan.mp4 (2.41 MB)
file 02_07-Side Note Merrygoround Scans.mp4 (2.20 MB)
file 02_08-Readahead.mp4 (5.39 MB)
file 02_09-Module Summary.mp4 (1.66 MB)
03. Types of Index Fragmentation (9 файлов)
file 03_01-Introduction.mp4 (1.05 MB)
file 03_02-Fragmentation in Action.mp4 (2.54 MB)
file 03_03-Demo Fragmentation Example.mp4 (8.69 MB)
file 03_04-Logical Fragmentation Details.mp4 (3.00 MB)
file 03_05-Extent Fragmentation.mp4 (5.19 MB)
file 03_06-Low Page Density.mp4 (3.93 MB)
file 03_07-Increased Buffer Pool Usage.mp4 (4.50 MB)
file 03_08-Demo Examining Buffer Pool Usage.mp4 (16.98 MB)
file 03_09-Module Summary.mp4 (1.20 MB)
04. Causes of Index Fragmentation (8 файлов)
file 04_01-Introduction.mp4 (1.20 MB)
file 04_02-Page Splits.mp4 (3.40 MB)
file 04_03-Page Split Causes.mp4 (5.43 MB)
file 04_04-Demo Page Split Causes.mp4 (15.67 MB)
file 04_05-Page Split Mechanism.mp4 (5.53 MB)
file 04_06-Demo Extra Logging From PageSplits.mp4 (8.82 MB)
file 04_07-Can DML Cause Fragmentation.mp4 (2.61 MB)
file 04_08-Module Summary.mp4 (1.30 MB)
05. Detecting Index Fragmentation (9 файлов)
file 05_01-Introduction and Page Split Types.mp4 (2.14 MB)
file 05_02-Tracking Page Splits.mp4 (3.46 MB)
file 05_03-Demo Tracking Page Splits.mp4 (15.61 MB)
file 05_04-Symptoms of Index Fragmentation.mp4 (1.38 MB)
file 05_05-sys.dm_db_index_physical_stats DMV.mp4 (2.76 MB)
file 05_06-sys.dm_db_index_physical_stats Modes.mp4 (2.56 MB)
file 05_07-Interpreting DMV Results.mp4 (2.76 MB)
file 05_08-Demo Using sys.dm_db_index_physical_stats.mp4 (20.38 MB)
file 05_09-Module Summary.mp4 (1.64 MB)
06. Avoiding Index Fragmentation (8 файлов)
file 06_01-Introduction.mp4 (1.28 MB)
file 06_02-Avoiding Index Fragmentation.mp4 (3.65 MB)
file 06_03-Using Index Fill Factors.mp4 (3.15 MB)
file 06_04-Setting and Choosing a Fill Factor.mp4 (4.51 MB)
file 06_05-Demo Viewing and Setting Index Fill Factors.mp4 (12.76 MB)
file 06_06-Removing Dead Weight.mp4 (2.46 MB)
file 06_07-Using the E Startup Option.mp4 (2.88 MB)
file 06_08-Module Summary.mp4 (2.09 MB)
07. Removing Index Fragmentation (13 файлов)
file 07_01-Introduction.mp4 (1.07 MB)
file 07_02-Comparing REBUILD and REORGANIZE.mp4 (7.47 MB)
file 07_03-When to Use REBUILD vs. REORGANIZE.mp4 (1.92 MB)
file 07_04-Demo REBUILD and REORGANIZE.mp4 (8.19 MB)
file 07_05-Useful Index Rebuild Options.mp4 (3.77 MB)
file 07_06-Online Index Operation Restrictions.mp4 (2.83 MB)
file 07_07-Demo Low Priority Lock Waits for Online Operations.mp4 (9.92 MB)
file 07_08-Removing Index Fragmentation.mp4 (4.55 MB)
file 07_09-Methodologies.mp4 (5.23 MB)
file 07_10-Inside Online Index REBUILD.mp4 (2.97 MB)
file 07_11-Inside REORGANIZE.mp4 (3.69 MB)
file 07_12-Module Summary.mp4 (1.59 MB)
file 07_13-Resources and Course Summary.mp4 (4.29 MB)
Exercise files (1 файл)
zip sqlserverindexfragmentationinternalsanalysissolutions.zip (1.37 MB)
Проверено 450 430 523 [обновить]

Отзывы к торренту SQL Server: Index Fragmentation Internals, Analysis, and Solutions (ENG) (2015)

Ваш отзыв будет ПЕРВЫМ!
(Быстрый вход) 

Информация

Посетители, находящиеся в группе Гости, не могут оставлять комментарии к данной публикации.