TorBT - Torrents and Magnet Links Search Engine

Lynda - SQL Server Performance for Developers

File Name
Size
6.5. Indexing/28.Overview of nonclustered indexes.mp4
18 MB
1.Introduction/01.Welcome.mp4
4.4 MB
1.Introduction/02.What you should know.en.srt
5.8 kB
1.Introduction/02.What you should know.mp4
4.8 MB
2.1. Query Execution/03.Execution plans introduction.en.srt
9.1 kB
2.1. Query Execution/03.Execution plans introduction.mp4
7.4 MB
2.1. Query Execution/04.How to read an execution plan.en.srt
12 kB
2.1. Query Execution/04.How to read an execution plan.mp4
11 MB
2.1. Query Execution/05.Execution plan XMLs.en.srt
5.1 kB
2.1. Query Execution/05.Execution plan XMLs.mp4
8.6 MB
2.1. Query Execution/06.Key lookup - When it's good and when it's bad.en.srt
7.8 kB
2.1. Query Execution/06.Key lookup - When it's good and when it's bad.mp4
8.0 MB
2.1. Query Execution/07.Nested loop vs. hash join.en.srt
9.0 kB
2.1. Query Execution/07.Nested loop vs. hash join.mp4
9.0 MB
2.1. Query Execution/08.Query Store.en.srt
15 kB
2.1. Query Execution/08.Query Store.mp4
16 MB
2.1. Query Execution/09.Stored procedures vs. dynamic SQL.en.srt
10 kB
2.1. Query Execution/09.Stored procedures vs. dynamic SQL.mp4
10 MB
2.1. Query Execution/10.Missing index warnings.en.srt
12 kB
2.1. Query Execution/10.Missing index warnings.mp4
12 MB
3.2. What Not to Do with SQL Server/11.Why cursors are bad.en.srt
6.8 kB
3.2. What Not to Do with SQL Server/11.Why cursors are bad.mp4
6.9 MB
3.2. What Not to Do with SQL Server/12.Why while loops are cursors.en.srt
9.9 kB
3.2. What Not to Do with SQL Server/12.Why while loops are cursors.mp4
11 MB
3.2. What Not to Do with SQL Server/13.What to do instead of cursors.en.srt
7.3 kB
3.2. What Not to Do with SQL Server/13.What to do instead of cursors.mp4
7.9 MB
3.2. What Not to Do with SQL Server/14.Why scalar UDFs are expensive.en.srt
11 kB
3.2. What Not to Do with SQL Server/14.Why scalar UDFs are expensive.mp4
12 MB
3.2. What Not to Do with SQL Server/15.Views and vested views.en.srt
17 kB
3.2. What Not to Do with SQL Server/15.Views and vested views.mp4
18 MB
3.2. What Not to Do with SQL Server/16.Why stored procedures are better than views for reports.en.srt
11 kB
3.2. What Not to Do with SQL Server/16.Why stored procedures are better than views for reports.mp4
13 MB
4.3. Datatypes and Design/17.The importance of datatypes.en.srt
15 kB
4.3. Datatypes and Design/17.The importance of datatypes.mp4
10 MB
4.3. Datatypes and Design/18.GUIDs vs. INT_BIGINT.en.srt
12 kB
4.3. Datatypes and Design/18.GUIDs vs. INT_BIGINT.mp4
10 MB
4.3. Datatypes and Design/19.Unicode data.en.srt
12 kB
4.3. Datatypes and Design/19.Unicode data.mp4
10 MB
4.3. Datatypes and Design/20.The perils of storing files in your database.en.srt
10 kB
4.3. Datatypes and Design/20.The perils of storing files in your database.mp4
10 MB
4.3. Datatypes and Design/21.What datatype conversions do to your query performance.en.srt
11 kB
4.3. Datatypes and Design/21.What datatype conversions do to your query performance.mp4
13 MB
5.4. Temporary Objects/22.Temp tables.en.srt
16 kB
5.4. Temporary Objects/22.Temp tables.mp4
14 MB
5.4. Temporary Objects/23.Table variables.en.srt
13 kB
5.4. Temporary Objects/23.Table variables.mp4
13 MB
5.4. Temporary Objects/24.In-memory temp tables.en.srt
17 kB
5.4. Temporary Objects/24.In-memory temp tables.mp4
18 MB
6.5. Indexing/25.Choosing a PK or clustered index key.en.srt
14 kB
6.5. Indexing/25.Choosing a PK or clustered index key.mp4
11 MB
6.5. Indexing/26.Why you want a clustered index.en.srt
12 kB
6.5. Indexing/26.Why you want a clustered index.mp4
14 MB
6.5. Indexing/27.Where you might not want a clustered index.en.srt
10 kB
6.5. Indexing/27.Where you might not want a clustered index.mp4
9.2 MB
6.5. Indexing/28.Overview of nonclustered indexes.en.srt
17 kB
1.Introduction/01.Welcome.en.srt
1.3 kB
6.5. Indexing/29.Included column explanation.en.srt
14 kB
6.5. Indexing/29.Included column explanation.mp4
15 MB
6.5. Indexing/30.Filtered indexes.en.srt
12 kB
6.5. Indexing/30.Filtered indexes.mp4
14 MB
7.6. Columnstore/31.What is a columnstore index.en.srt
15 kB
7.6. Columnstore/31.What is a columnstore index.mp4
14 MB
7.6. Columnstore/32.Clustered columnstore and DW.en.srt
14 kB
7.6. Columnstore/32.Clustered columnstore and DW.mp4
17 MB
7.6. Columnstore/33.Nonclustered columnstore - Why.en.srt
7.7 kB
7.6. Columnstore/33.Nonclustered columnstore - Why.mp4
7.2 MB
7.6. Columnstore/34.Using filtered nonclustered columnstore for HTAP.en.srt
12 kB
7.6. Columnstore/34.Using filtered nonclustered columnstore for HTAP.mp4
14 MB
8.7. Isolation Levels/35.Transaction isolation.en.srt
14 kB
8.7. Isolation Levels/35.Transaction isolation.mp4
11 MB
8.7. Isolation Levels/36.RCSI - Why it's good.en.srt
11 kB
8.7. Isolation Levels/36.RCSI - Why it's good.mp4
10 MB
8.7. Isolation Levels/37.Implicit transactions - Why they're terrible.en.srt
11 kB
8.7. Isolation Levels/37.Implicit transactions - Why they're terrible.mp4
8.6 MB
9.Conclusion/38.Next steps.en.srt
4.8 kB
9.Conclusion/38.Next steps.mp4
3.4 MB
Exercise Files/Ex_Files_SQL_Server_Performance_Developers.zip
28 kB