Skip to main content
SQL DBA School
Hands-On SQL Server Training
Labs • Portfolio • Interview Prep • Career Support
info@SQLdbaSchool.com
+1 (716) 464-0768
SQL
DBA
SQL DBA School
Learn SQL Server • Build Portfolio Proof • Become Interview-Ready
Student Login
Start Learning
Hire Candidates
Apply for Jobs
Home
Learning Paths
Choose Your Best Starting Point
Start From Zero
New to SQL or IT? Begin with the clean beginner roadmap.
Beginner Path
Become a SQL DBA
Build the job-ready SQL Server DBA skill path.
Career Path
Advance My Career
Move into tuning, cloud, automation, and higher-value roles.
Growth Path
Courses
Featured SQL Server Training
All Courses
Browse every SQL DBA learning path
Database Foundations
Best first step for newer learners
Complete SQL Server DBA Course
Core DBA training, labs, and portfolio work
Performance Tuning
Evidence-first troubleshooting and tuning
Career Center
From Skills to Opportunities
Apply Once
Join the candidate pool for matched roles
SQL Jobs
Explore remote and on-site opportunities
Employer Hiring Partners
Companies can request SQL DBA candidates
Remote DBA Roadmap
Skills, proof, and remote-readiness plan
SQL DBA Careers Guide
Skills, portfolio, pay, and job strategy
Resources
Tools, Guides, and Learning Support
SQL Downloads Hub
SQL Server, SSMS, tools, and setup help
Free SQL Training Guide
How to learn free and become job-ready
DBA Training Roadmap
Skills, proof, and certification strategy
Courses with Certificate
Certificate-ready learning paths
About
School, Trust, and Support
About SQL DBA School
Story, founder, training model, outcomes
Contact
Support, careers, and partner inquiries
Student Account
Login and course access
Become a Teacher
Teach with SQL DBA School
Hire Candidates
Contact
SQL DBA School mobile navigation
SQL Career School
Apply Now
SQL
DBA
SQL DBA School
Learn • Practice • Build Proof • Get Interview-Ready
Start Learning
Apply
Hire
Home
Paths
Learn
Jobs
Hire
T-SQL Enhancements in SQL Server 2016 for Developers and DBAs
1 Section
10 Lessons
Lifetime
1 Section
10 Lessons
Lifetime
Expand all sections
Collapse all sections
T-SQL Enhancements in SQL Server 2016
10 Items
3.1
TRUNCATE TABLE WITH PARTITIONS T-SQL Enhancement in SQL Server 2016
5 Minutes
3.2
DROP IF EXISTS T-SQL Enhancement in SQL Server 2016
5 Minutes
3.3
ALTER TABLE WITH (ONLINE=ON | OFF) T-SQL Enhancement in SQL Server 2016
5 Minutes
3.4
MAXDOP for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP T-SQL Enhancement in SQL Server 2016
5 Minutes
3.5
ALTER DATABASE SET AUTOGROW_SINGLE_FILE T-SQL Enhancement in SQL Server 2016
5 Minutes
3.6
ALTER DATABASE SET AUTOGROW_ALL_FILES T-SQL Enhancement in SQL Server 2016
5 Minutes
3.7
COMPRESS and DECOMPRESS T-SQL Enhancement in SQL Server 2016
5 Minutes
3.8
STRING_SPLIT Function and STRING_ESCAPE Function in SQL Server 2016
5 Minutes
3.9
FORMATMESSAGE Statement T-SQL Enhancement in SQL Server 2016
5 Minutes
3.10
SERVERPROPERTY Function T-SQL Enhancement in SQL Server 2016
5 Minutes
This content is protected, please
login
and
enroll
in the course to view this content!
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content