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