|
|
0
|
|
0 B
|
|
|
001 Démo _ Do you know the covering Index _.mp4
|
MP4
|
86.9 MB
|
|
|
001 What are we going to see in this course _.en.srt
|
SRT
|
1.8 KB
|
|
|
001 What are we going to see in this course _.mp4
|
MP4
|
19.4 MB
|
|
|
001 What is a index _.en.srt
|
SRT
|
2.4 KB
|
|
|
001 What is a index _.mp4
|
MP4
|
20.1 MB
|
|
|
001 Why is fragmentation important_.en.srt
|
SRT
|
4.9 KB
|
|
|
1
|
|
459.4 KB
|
|
|
001 Démo _ Do you know the covering Index _.en.srt
|
SRT
|
8.2 KB
|
|
|
001 Why is fragmentation important_.mp4
|
MP4
|
26.5 MB
|
|
|
002 Example of fragmentation.mp4
|
MP4
|
57.8 MB
|
|
|
2
|
|
192.7 KB
|
|
|
002 Démo _ Define the files when creating the DB.en.srt
|
SRT
|
4.8 KB
|
|
|
002 Démo _ Define the files when creating the DB.mp4
|
MP4
|
48 MB
|
|
|
002 Démo _ Learn the INCLUDE clause on your index.en.srt
|
SRT
|
8.6 KB
|
|
|
002 Démo _ Learn the INCLUDE clause on your index.mp4
|
MP4
|
88.8 MB
|
|
|
002 Example of fragmentation.en.srt
|
SRT
|
5.2 KB
|
|
|
002 Setting up databases.en.srt
|
SRT
|
1.3 KB
|
|
|
002 Setting up databases.mp4
|
MP4
|
15.7 MB
|
|
|
002 setup database.sql
|
SQL
|
819.2 B
|
|
|
003 Démo _ Définition and création of a filegroup.en.srt
|
SRT
|
7.1 KB
|
|
|
003 Démo _ Tracking page splits.en.srt
|
SRT
|
2.6 KB
|
|
|
3
|
|
58.8 KB
|
|
|
003 Démo _ Définition and création of a clustered index.en.srt
|
SRT
|
9.4 KB
|
|
|
003 Démo _ Définition and création of a clustered index.mp4
|
MP4
|
89.9 MB
|
|
|
003 Démo _ Définition and création of a filegroup.mp4
|
MP4
|
56.3 MB
|
|
|
003 Démo _ Tracking page splits.mp4
|
MP4
|
29.8 MB
|
|
|
003 Learn to consolidate your indexes!.en.srt
|
SRT
|
10.4 KB
|
|
|
003 Learn to consolidate your indexes!.mp4
|
MP4
|
107.8 MB
|
|
|
003 structure index_UK.sql
|
SQL
|
2.1 KB
|
|
|
004 What is the FILLFACTOR_.en.srt
|
SRT
|
7.2 KB
|
|
|
4
|
|
495.7 KB
|
|
|
004 Définition and création of a non clustered index.en.srt
|
SRT
|
5.7 KB
|
|
|
004 Définition and création of a non clustered index.mp4
|
MP4
|
63.4 MB
|
|
|
004 Démo _ Let's discover the UNIQUE index.en.srt
|
SRT
|
3.7 KB
|
|
|
004 Démo _ Let's discover the UNIQUE index.mp4
|
MP4
|
41 MB
|
|
|
004 Démo _ What is the Containment database _.en.srt
|
SRT
|
4.7 KB
|
|
|
004 Démo _ What is the Containment database _.mp4
|
MP4
|
47.7 MB
|
|
|
004 What is the FILLFACTOR_.mp4
|
MP4
|
59.4 MB
|
|
|
004 structure index non clustered_UK.sql
|
SQL
|
2.1 KB
|
|
|
005 Démo _ Explanation of the compatibility mode.mp4
|
MP4
|
35.9 MB
|
|
|
005 Structure of the clustered index with a non clustered index.en.srt
|
SRT
|
4.4 KB
|
|
|
005 Structure of the clustered index with a non clustered index.mp4
|
MP4
|
42.3 MB
|
|
|
005 structure index clustered with no clustered_UK.sql
|
SQL
|
2.2 KB
|
|
|
5
|
|
24.2 KB
|
|
|
005 Démo _ Explanation of the compatibility mode.en.srt
|
SRT
|
3 KB
|
|
|
005 Démo _ Indexing and column order.en.srt
|
SRT
|
4.7 KB
|
|
|
005 Démo _ Indexing and column order.mp4
|
MP4
|
52.6 MB
|
|
|
005 Rebuild Index Vs REORGANIZE.en.srt
|
SRT
|
6.3 KB
|
|
|
005 Rebuild Index Vs REORGANIZE.mp4
|
MP4
|
62.5 MB
|
|
|
006 Démo _ Be careful about the duplicate index !.en.srt
|
SRT
|
3.6 KB
|
|
|
006 Démo _ Be careful about the duplicate index !.mp4
|
MP4
|
39.8 MB
|
|
|
006 Démo _ OFF LINE and EMERGENCY on a database.en.srt
|
SRT
|
3.8 KB
|
|
|
006 Démo _ OFF LINE and EMERGENCY on a database.mp4
|
MP4
|
40.6 MB
|
|
|
006 Démo _ The table SEEK.en.srt
|
SRT
|
4.3 KB
|
|
|
006 Démo _ The table SEEK.mp4
|
MP4
|
36.9 MB
|
|
|
006 REBUILD INDEX with the option ABORT_AFTER_WAIT.en.srt
|
SRT
|
4.3 KB
|
|
|
006 REBUILD INDEX with the option ABORT_AFTER_WAIT.mp4
|
MP4
|
36.6 MB
|
|
|
006 SEEK_UK.sql
|
SQL
|
1.3 KB
|
|
|
6
|
|
387.3 KB
|
|
|
7
|
|
209.2 KB
|
|
|
007 Conclusion on the Index.en.srt
|
SRT
|
3.5 KB
|
|
|
007 Conclusion on the Index.mp4
|
MP4
|
20.3 MB
|
|
|
007 Démo _ SINGLE_USER et RESTRICTED_USER, READ_ONLY.en.srt
|
SRT
|
6.3 KB
|
|
|
007 Démo _ SINGLE_USER et RESTRICTED_USER, READ_ONLY.mp4
|
MP4
|
56.5 MB
|
|
|
007 Démo _ The table SCAN.en.srt
|
SRT
|
7.2 KB
|
|
|
007 Démo _ The table SCAN.mp4
|
MP4
|
74.6 MB
|
|
|
007 Démo _ What is the OVER indexing _.en.srt
|
SRT
|
4.8 KB
|
|
|
007 Démo _ What is the OVER indexing _.mp4
|
MP4
|
40.7 MB
|
|
|
007 Table scan_UK.sql
|
SQL
|
2.8 KB
|
|
|
008 Create a database by attaching a file.en.srt
|
SRT
|
5 KB
|
|
|
008 Create a database by attaching a file.mp4
|
MP4
|
50 MB
|
|
|
008 Démo _ In search of the perfect index.en.srt
|
SRT
|
3.9 KB
|
|
|
008 Démo _ In search of the perfect index.mp4
|
MP4
|
41.1 MB
|
|
|
008 covering index UK.sql
|
SQL
|
2.8 KB
|
|
|
8
|
|
61.9 KB
|
|
|
9
|
|
401.3 KB
|
|
|
009 01 Best uses for INCLUDE_UK.sql
|
SQL
|
3.7 KB
|
|
|
009 AUTO options on a database.en.srt
|
SRT
|
3.9 KB
|
|
|
009 AUTO options on a database.mp4
|
MP4
|
39.6 MB
|
|
|
009 Démo _ Improve performance by deactivating the indexes.en.srt
|
SRT
|
5.2 KB
|
|
|
009 Démo _ Improve performance by deactivating the indexes.mp4
|
MP4
|
47.7 MB
|
|
|
010 Avoid an index clustered on a NEWID column !.en.srt
|
SRT
|
5.2 KB
|
|
|
010 Avoid an index clustered on a NEWID column !.mp4
|
MP4
|
52.7 MB
|
|
|
010 Consolidate index_UK.sql
|
SQL
|
5.7 KB
|
|
|
010 What is the TARGET RECOVERY Time_.en.srt
|
SRT
|
2.5 KB
|
|
|
010 What is the TARGET RECOVERY Time_.mp4
|
MP4
|
21.2 MB
|
|
|
010 set up_1.sql
|
SQL
|
6.7 KB
|
|
|
010 set up_2.sql
|
SQL
|
17.3 KB
|
|
|
10
|
|
47.7 KB
|
|
|
011 But what is CHECKPOINT anyway_.en.srt
|
SRT
|
10 KB
|
|
|
011 But what is CHECKPOINT anyway_.mp4
|
MP4
|
77.5 MB
|
|
|
011 Démo _ What is a filtered index _.en.srt
|
SRT
|
3.8 KB
|
|
|
011 Démo _ What is a filtered index _.mp4
|
MP4
|
38.4 MB
|
|
|
011 INDEx UNIQUE_UK.sql
|
SQL
|
2.1 KB
|
|
|
11
|
|
293.6 KB
|
|
|
012 9-order-of-columns-index.sql
|
SQL
|
4.1 KB
|
|
|
012 Demo_ Changing the DB owner.en.srt
|
SRT
|
4.7 KB
|
|
|
012 Demo_ Changing the DB owner.mp4
|
MP4
|
49.5 MB
|
|
|
12
|
|
59 KB
|
|
|
012 Démo _ Filtered indexes and the cache plan.en.srt
|
SRT
|
8.3 KB
|
|
|
012 Démo _ Filtered indexes and the cache plan.mp4
|
MP4
|
85 MB
|
|
|
013 Duplicate Index_UK.sql
|
SQL
|
2.7 KB
|
|
|
013 Démo _ What is the TRUSTWORTHY option on a Database _.en.srt
|
SRT
|
4.5 KB
|
|
|
013 How to choice your clustered index _.mp4
|
MP4
|
35.4 MB
|
|
|
13
|
|
217.1 KB
|
|
|
013 Démo _ What is the TRUSTWORTHY option on a Database _.mp4
|
MP4
|
42.6 MB
|
|
|
013 How to choice your clustered index _.en.srt
|
SRT
|
6 KB
|
|
|
014 Démo_ What is the different database recovery model on your database _.mp4
|
MP4
|
62.6 MB
|
|
|
14
|
|
507.7 KB
|
|
|
014 2-OverIndexing_UK.sql
|
SQL
|
3.7 KB
|
|
|
014 Démo _ The index columnstore.en.srt
|
SRT
|
6.2 KB
|
|
|
014 Démo _ The index columnstore.mp4
|
MP4
|
73.8 MB
|
|
|
014 Démo_ What is the different database recovery model on your database _.en.srt
|
SRT
|
7.5 KB
|
|
|
015 Démo _ Let's a create a indexed view !.en.srt
|
SRT
|
4.6 KB
|
|
|
015 Démo _ Let's a create a indexed view !.mp4
|
MP4
|
49.9 MB
|
|
|
015 Démo _ What is the MAXDOP on your database _.en.srt
|
SRT
|
3.5 KB
|
|
|
015 Démo _ What is the MAXDOP on your database _.mp4
|
MP4
|
32 MB
|
|
|
15
|
|
159.8 KB
|
|
|
015 In search of the perfect index UK .sql
|
SQL
|
2.2 KB
|
|
|
16
|
|
318.1 KB
|
|
|
016 Démo_ The CHECKSUM option on your database.en.srt
|
SRT
|
2.9 KB
|
|
|
016 Démo_ The CHECKSUM option on your database.mp4
|
MP4
|
24.6 MB
|
|
|
016 deactivation_index_UK.sql
|
SQL
|
3.9 KB
|
|
|
017 GUID Performance_UK.sql
|
SQL
|
2.3 KB
|
|
|
17
|
|
403.1 KB
|
|
|
017 Démo _ How to change your collation _.en.srt
|
SRT
|
3.9 KB
|
|
|
017 Démo _ How to change your collation _.mp4
|
MP4
|
38.9 MB
|
|
|
018 Index+filtré_UK.sql
|
SQL
|
2.4 KB
|
|
|
18
|
|
41 KB
|
|
|
018 Démo_ Definition and activation of a broker.en.srt
|
SRT
|
3.9 KB
|
|
|
018 Démo_ Definition and activation of a broker.mp4
|
MP4
|
27.2 MB
|
|
|
019 03 Filtered indexes and plan caching_UK.sql
|
SQL
|
4.4 KB
|
|
|
019 Démo _ SET ANSI_NULL and SET QUOTE IDENTIFIER.en.srt
|
SRT
|
3.8 KB
|
|
|
019 Démo _ SET ANSI_NULL and SET QUOTE IDENTIFIER.mp4
|
MP4
|
37.7 MB
|
|
|
19
|
|
118.1 KB
|
|
|
020 Démo _ Change configurations limited to databases.en.srt
|
SRT
|
5.4 KB
|
|
|
020 Démo _ Change configurations limited to databases.mp4
|
MP4
|
61.7 MB
|
|
|
20
|
|
41.5 KB
|
|
|
021 Démo _ What is the CHANGE TRACKING on your database _.mp4
|
MP4
|
41.9 MB
|
|
|
021 colmunstore index_UK.sql
|
SQL
|
3.7 KB
|
|
|
21
|
|
344.5 KB
|
|
|
021 Démo _ What is the CHANGE TRACKING on your database _.en.srt
|
SRT
|
4.5 KB
|
|
|
022 Démo _ Why do not activate the DB_CHAINING on your BDD _.en.srt
|
SRT
|
5.2 KB
|
|
|
022 Démo _ Why do not activate the DB_CHAINING on your BDD _.mp4
|
MP4
|
48.2 MB
|
|
|
22
|
|
503.9 KB
|
|
|
022 Index view UK.sql
|
SQL
|
3.3 KB
|
|
|
023 Démo _ Let's discover the powerful Query Store !.en.srt
|
SRT
|
4.1 KB
|
|
|
023 Démo _ Let's discover the powerful Query Store !.mp4
|
MP4
|
36.6 MB
|
|
|
23
|
|
172 KB
|
|
|
024 Démo _ Discover the accelerated recovery database on SQL Server 2019.en.srt
|
SRT
|
4.6 KB
|
|
|
024 Démo _ Discover the accelerated recovery database on SQL Server 2019.mp4
|
MP4
|
46.2 MB
|
|
|
24
|
|
320.4 KB
|
|
|
024 FragmentationExample_UK.sql
|
SQL
|
2.2 KB
|
|
|
25
|
|
345.2 KB
|
|
|
025 Démo _ Be careful on your AUTOGROW settings !.en.srt
|
SRT
|
4.3 KB
|
|
|
025 Démo _ Be careful on your AUTOGROW settings !.mp4
|
MP4
|
47.8 MB
|
|
|
025 Tack split page UK.sql
|
SQL
|
2.2 KB
|
|
|
025 Tack split page UK_2.sql
|
SQL
|
1.3 KB
|
|
|
026 Conclusion on this chapter.mp4
|
MP4
|
7.2 MB
|
|
|
26
|
|
321 KB
|
|
|
026 FILLFACTOR_UK.sql
|
SQL
|
4.1 KB
|
|
|
027 CreateFragmentation_UK.sql
|
SQL
|
1.5 KB
|
|
|
027 Rebuild VS REORGANIZE_UK.sql
|
SQL
|
2.1 KB
|
|
|
27
|
|
379.9 KB
|
|
|
028 REBUILD avec ABORT AFTER WAIT2_UK.sql
|
SQL
|
204.8 B
|
|
|
28
|
|
165.2 KB
|
|
|
028 REBUILD avec ABORT AFTER WAIT_UK.sql
|
SQL
|
2.4 KB
|
|
|
29
|
|
130.4 KB
|
|
|
30
|
|
451.2 KB
|
|
|
031 Define the files when creating the DB_UK.sql
|
SQL
|
1.2 KB
|
|
|
31
|
|
504 KB
|
|
|
032 Filegroup_UK.sql
|
SQL
|
1.7 KB
|
|
|
32
|
|
308.4 KB
|
|
|
33
|
|
399.7 KB
|
|
|
033 Activation of the Contained database_UK.sql
|
SQL
|
1 KB
|
|
|
34
|
|
235.4 KB
|
|
|
034 Compatibility mode on a database UK .sql
|
SQL
|
1.3 KB
|
|
|
35
|
|
365.7 KB
|
|
|
035 OFF LINE and EMERGENCY on a database_UK.sql
|
SQL
|
1 KB
|
|
|
036 RESTRICTED_USER et SINGLE_USERQuery 1_UK .sql
|
SQL
|
2.4 KB
|
|
|
036 RESTRICTED_USER et SINGLE_USERQuery 2_UK .sql
|
SQL
|
102.4 B
|
|
|
037 Creating a database by attaching a file_UK.sql
|
SQL
|
1.6 KB
|
|
|
038 Changing options to AUTO on a DB_UK.sql
|
SQL
|
1.4 KB
|
|
|
039 The TARGET_RECOVERY_TIME on a database._UK.sql
|
SQL
|
921.6 B
|
|
|
040 CHECKPOINT_UK.sql
|
SQL
|
2.3 KB
|
|
|
043 Different recovery models_UK.sql
|
SQL
|
2.5 KB
|
|
|
045 checksum_UK.sql
|
SQL
|
1.1 KB
|
|
|
047 BROKER_UK.sql
|
SQL
|
2.8 KB
|
|
|
048 ANSI_NULL_UK.sql
|
SQL
|
1.9 KB
|
|
|
049 config limitée BDD_UK.sql
|
SQL
|
3.1 KB
|
|
|
050 CHANGE TRACKING_UK.sql
|
SQL
|
2.8 KB
|
|
|
051 DB_CHAINING_UK.sql
|
SQL
|
2.4 KB
|
|
|
052 QUERY STORE_UK.sql
|
SQL
|
716.8 B
|
|
|
053 Query1_UK.sql
|
SQL
|
2.2 KB
|
|
|
053 Query2_UK.sql
|
SQL
|
204.8 B
|
|
|
053 Query3_UK.sql
|
SQL
|
307.2 B
|
|
|
054 AUTOGROW_UK.sql
|
SQL
|
2.1 KB
|
|
|
TutsNode.com.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
|
|
36
|
|
81.9 KB
|
|
|
37
|
|
137.3 KB
|
|
|
38
|
|
281.3 KB
|
|
|
39
|
|
147.7 KB
|
|
|
40
|
|
433.9 KB
|
|
|
41
|
|
442.2 KB
|
|
|
42
|
|
61 KB
|
|
|
43
|
|
111.1 KB
|
|
|
44
|
|
503.8 KB
|
|
|
45
|
|
214.4 KB
|
|
|
46
|
|
277.5 KB
|
|
|
47
|
|
495.4 KB
|
|
|
48
|
|
373.9 KB
|
|
|
49
|
|
301.1 KB
|
|
|
50
|
|
219.8 KB
|
|
|
51
|
|
435.4 KB
|
|
|
52
|
|
84.6 KB
|
|
|
53
|
|
275.1 KB
|
