Learn Microsoft SQL Server 2016 Best Practices for VLDB

Learn Microsoft SQL Server 2016 Best Practices for VLDB

The at the end of this course you will know how use Microsoft SQL Server 2016 with Very Large Databases, how its been improved from earlier version and get years of experience in this short course.

• Understand the Best Practices for databases for growth across files.
• Create file groups and move Data between file groups.
• Partition tables and create Memory optimized tables.
• How to use Mount Points.
• Use SQL Profiler to find improvements in database designs.

Learning best practices for very large databases in SQL 2016

Url: View Details

What you will learn

• At the end of this you will understand how to find performance issues and understand the best practices for large databases.
• How you can optimism disk subsystems and memory management including row and page compression.

Rating: 4.35

Level: Intermediate Level

Duration: 2 hours

Instructor: John Hall