Lynda SQL Server Performance for Developers | B52B6A9176060181F551379FD22BB1082E1595E0

Lynda SQL Server Performance for Developers

Name	Lynda - SQL Server Performance for Developers	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	446.8 MB
Total Files	77
Last Seen
Hash	B52B6A9176060181F551379FD22BB1082E1595E0

/6.5. Indexing/
28.Overview of nonclustered indexes.mp4	19.0 MB
1.Introduction/
01.Welcome.mp4	4.6 MB
02.What you should know.en.srt	5.9 KB
02.What you should know.mp4	5.0 MB
01.Welcome.en.srt	1.3 KB
2.1. Query Execution/
03.Execution plans introduction.en.srt	9.4 KB
03.Execution plans introduction.mp4	7.8 MB
04.How to read an execution plan.en.srt	11.9 KB
04.How to read an execution plan.mp4	11.8 MB
05.Execution plan XMLs.en.srt	5.2 KB
05.Execution plan XMLs.mp4	9.1 MB
06.Key lookup - When it's good and when it's bad.en.srt	8.0 KB
06.Key lookup - When it's good and when it's bad.mp4	8.4 MB
07.Nested loop vs. hash join.en.srt	9.2 KB
07.Nested loop vs. hash join.mp4	9.5 MB
08.Query Store.en.srt	15.6 KB
08.Query Store.mp4	16.6 MB
09.Stored procedures vs. dynamic SQL.en.srt	10.3 KB
09.Stored procedures vs. dynamic SQL.mp4	10.7 MB
10.Missing index warnings.en.srt	11.8 KB
10.Missing index warnings.mp4	12.7 MB
3.2. What Not to Do with SQL Server/
11.Why cursors are bad.en.srt	7.0 KB
11.Why cursors are bad.mp4	7.2 MB
12.Why while loops are cursors.en.srt	10.1 KB
12.Why while loops are cursors.mp4	11.5 MB
13.What to do instead of cursors.en.srt	7.5 KB
13.What to do instead of cursors.mp4	8.3 MB
14.Why scalar UDFs are expensive.en.srt	11.1 KB
14.Why scalar UDFs are expensive.mp4	12.8 MB
15.Views and vested views.en.srt	17.7 KB
15.Views and vested views.mp4	18.7 MB
16.Why stored procedures are better than views for reports.en.srt	11.4 KB
16.Why stored procedures are better than views for reports.mp4	13.7 MB
4.3. Datatypes and Design/
17.The importance of datatypes.en.srt	15.3 KB
17.The importance of datatypes.mp4	10.7 MB
18.GUIDs vs. INT_BIGINT.en.srt	11.9 KB
18.GUIDs vs. INT_BIGINT.mp4	11.0 MB
19.Unicode data.en.srt	12.0 KB
19.Unicode data.mp4	10.5 MB
20.The perils of storing files in your database.en.srt	10.5 KB
20.The perils of storing files in your database.mp4	10.7 MB
21.What datatype conversions do to your query performance.en.srt	11.2 KB
21.What datatype conversions do to your query performance.mp4	13.5 MB
5.4. Temporary Objects/
22.Temp tables.en.srt	16.2 KB
22.Temp tables.mp4	14.9 MB
23.Table variables.en.srt	13.4 KB
23.Table variables.mp4	14.0 MB
24.In-memory temp tables.en.srt	17.4 KB
24.In-memory temp tables.mp4	18.5 MB
6.5. Indexing/
25.Choosing a PK or clustered index key.en.srt	14.6 KB
25.Choosing a PK or clustered index key.mp4	11.2 MB
26.Why you want a clustered index.en.srt	12.3 KB
26.Why you want a clustered index.mp4	14.6 MB
27.Where you might not want a clustered index.en.srt	10.2 KB
27.Where you might not want a clustered index.mp4	9.6 MB
28.Overview of nonclustered indexes.en.srt	17.1 KB
29.Included column explanation.en.srt	13.9 KB
29.Included column explanation.mp4	15.5 MB
30.Filtered indexes.en.srt	12.6 KB
30.Filtered indexes.mp4	14.4 MB
7.6. Columnstore/
31.What is a columnstore index.en.srt	15.3 KB
31.What is a columnstore index.mp4	14.9 MB
32.Clustered columnstore and DW.en.srt	14.8 KB
32.Clustered columnstore and DW.mp4	17.6 MB
33.Nonclustered columnstore - Why.en.srt	7.9 KB
33.Nonclustered columnstore - Why.mp4	7.5 MB
34.Using filtered nonclustered columnstore for HTAP.en.srt	12.6 KB
34.Using filtered nonclustered columnstore for HTAP.mp4	15.0 MB
8.7. Isolation Levels/
35.Transaction isolation.en.srt	14.1 KB
35.Transaction isolation.mp4	11.4 MB
36.RCSI - Why it's good.en.srt	10.9 KB
36.RCSI - Why it's good.mp4	10.8 MB
37.Implicit transactions - Why they're terrible.en.srt	11.2 KB
37.Implicit transactions - Why they're terrible.mp4	9.0 MB
9.Conclusion/
38.Next steps.en.srt	4.9 KB
38.Next steps.mp4	3.6 MB
Exercise Files/
Ex_Files_SQL_Server_Performance_Developers.zip	29.2 KB
Total files 77