SQL Server Understanding and Using DBCC Commands | 656B66533BCA212F21C2EA275153A72CF703EC54

SQL Server Understanding and Using DBCC Commands

Name	SQL Server Understanding and Using DBCC Commands	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	469.5 MB
Total Files	60
Hash	656B66533BCA212F21C2EA275153A72CF703EC54

/01 Course Overview/
1. Introduction.mp4	6.9 MB
/02 Introduction/
1. Introduction and Responsibilities of a DBA.mp4	2.8 MB
2. What This Course Covers.mp4	6.0 MB
3. Course Structure and Module Summary.mp4	1.4 MB
/03 Basic Commands/
1. Introduction and What Are DBCC Commands.mp4	3.4 MB
2. DBCC Resources.mp4	2.1 MB
3. Testing DBCC Commands.mp4	3.3 MB
4. Undocumented Commands.mp4	3.2 MB
5. DBCC HELP.mp4	2.3 MB
6. DBCC TRACEON, DBCC TRACEOFF, and DBCC TRACESTATUS.mp4	5.9 MB
7. Demo Using Basic DBCC Commands.mp4	26.5 MB
8. Takeaways and Module Summary.mp4	2.7 MB
/04 Informational Commands/
01. Introduction.mp4	1.5 MB
02. DBCC SQLPEERF.mp4	6.1 MB
03. Demo Using DBCC SQLPERF.mp4	38.6 MB
04. DBCC SHOW_STATISTICS.mp4	6.3 MB
05. Demo Using DBCC SHOW_STATISTICS.mp4	33.6 MB
06. DBCC USEROPTIONS.mp4	3.0 MB
07. Additional Commands and DBCC OPENTRAN.mp4	4.5 MB
08. DBCC INPUTBUFFER and DBCC OUTPUTBUFFER.mp4	2.3 MB
09. DBCC PROCCACHE and DBCC SHOWCONTIG.mp4	3.2 MB
10. Demo Using DMOs Instead of DBCC .mp4	35.1 MB
11. Takeaways and Module Summary.mp4	2.8 MB
/05 Maintenance Commands/
1. Introduction and DBCC DROPCLEANBUFFERS.mp4	4.9 MB
2. DBCC FREEPROCCACHE.mp4	3.4 MB
3. DBCC FREESYSTEMCACHE and FREESESSIONCACHE.mp4	3.3 MB
4. DBCC FLUSHPROCINDB.mp4	1.9 MB
5. Demo Commands to Clear Buffer Pool and Procedure Cache.mp4	52.3 MB
6. DBCC SHRINKDATABASE and DBCC SHRINKFILE.mp4	5.3 MB
7. Demo Effects of SHRINK Commands.mp4	38.4 MB
8. DBCC UPDATEUSAGE and DBCC CLEANTABLE.mp4	4.7 MB
9. Deprecated Commands, Takeaways, and Module Summary.mp4	4.8 MB
/06 Validation Commands/
1. Introduction.mp4	2.2 MB
2. DBCC CHECKCONSTRAINTS.mp4	4.4 MB
3. Demo Using DBCC CHECKCONSTRAINTS.mp4	18.3 MB
4. DBCC CHECKIDENT.mp4	3.2 MB
5. Demo Using DBCC CHECKIDENT.mp4	14.6 MB
6. Takeaways and Module Summary.mp4	2.3 MB
/07 Undocumented Commands/
1. Introduction and DBCC LOGINFO.mp4	4.8 MB
2. Demo Using DBCC LOGINFO.mp4	26.0 MB
3. DBCC IND, DBCC PAGE, and DBCC DBINFO.mp4	4.3 MB
4. Demo Exploring Internals with DBCC Commands.mp4	56.9 MB
5. Takeaways and Module Summary.mp4	2.7 MB
6. Where to Go Next and Course Summary.mp4	3.0 MB
/.../2-sql-server-understanding-using-dbcc-commands-m2-exercise-files/
1_DBCC_Basics_PS.sql	2.9 KB
/.../3-sql-server-understanding-using-dbcc-commands-m3-exercise-files/
2_DBCC_SQLPERF_PS.sql	8.0 KB
3_DBCC_SHOWSTATISTICS_PS.sql	3.2 KB
4_DBCC_DBCCtoDMO_PS.sql	2.5 KB
/.../4-sql-server-understanding-using-dbcc-commands-m4-exercise-files/
5_DBCC_Maintenance_FREE_PS.sql	7.0 KB
6_DBCC_Maintenance_Shrink_PS.sql	7.4 KB
/.../5-sql-server-understanding-using-dbcc-commands-m5-exercise-files/
7_DBCC_Validation_Constraints_PS.sql	2.0 KB
8_DBCC_Validation_Ident_PS.sql	2.0 KB
/.../6-sql-server-understanding-using-dbcc-commands-m6-exercise-files/
10_DBCC_Undocumented_PAGEIND_PS.sql	3.0 KB
9_DBCC_Undocumented_LOGINFO_PS.sql	2.7 KB
/Exercises files and slides/
1-sql-server-understanding-using-dbcc-commands-m1-slides.pdf	430.0 KB
2-sql-server-understanding-using-dbcc-commands-m2-slides.pdf	681.4 KB
3-sql-server-understanding-using-dbcc-commands-m3-slides.pdf	826.4 KB
4-sql-server-understanding-using-dbcc-commands-m4-slides.pdf	910.0 KB
5-sql-server-understanding-using-dbcc-commands-m5-slides.pdf	568.4 KB
6-sql-server-understanding-using-dbcc-commands-m6-slides.pdf	757.6 KB
Total files 60