Top Ten Things Every DBA should know about SQL Server: 1. A Full Backup Does NOT Truncate the Transaction Log 2. Transaction Log Not Shrinking? OK, Shrink it Twice 3. Yes, You Can Recover your Data Right up to the Point of Failure 4. Data Partitioning Improves Performance for Large Tables 5. Security - Ownership Chains Are a Good Thing 6. Has Microsoft Deprecated your SQL Code? 7. DTS Has Been Deprecated, Get on the SSIS Bandwagon before 2011 8. Data Compression Improves Performance, too 9. Change Data Capture Simplifies the Incremental Load 10. Books Online Is Still the Best - Study24x7
Social learning Network
study24x7

Default error msg

Login

New to Study24x7 ? Join Now
Already have an account? Login
googlePlay app_img
trilok sharma
11 Apr 2019 10:33 AM study24x7 study24x7

Top Ten Things Every DBA should know about SQL Server: 1. A Full Backup Does NOT Truncate the Transaction Log 2. Transaction Log Not Shrinking? OK, Shrink it Twice 3. Yes, You Can Recover your Data Right up to the Point of Failure 4. Data Partitioning Improves Performance for Lar...

See more

NET IIT Entrance GATE
Like Comment Share
study24x7
Write a comment
Related Questions
500+   more Questions to answer

Popular Courses

Reasoning Special by Parwez Sir for... All Levels हिन्दी By Reasoning special by Parwez Alam
Introduction to Google Ads All Levels English By Digital World
NDA Exam online Course - 2021 Beginners Level English By CADETS PRIME DEFENCE 15,000 25,000 40% off
CAPF(AC) | Test Series All Levels English By Ajabs Academy Pvt Ltd
Free SEO training: SEO for beginner... Beginners Level English By Digital Marketing - Learn SEO, PPC,...
NDA Exam Online Course 2021-2022 Beginners Level English By Sigma Classes 15,000 20,000 25% off
Delhi Police Constable 2020 Live on... All Levels English By PARINAM COACHING CENTRE PVT LTD 1,499 2,499 40% off
Free SEO Link Building Guide 2019 All Levels English By Digital Marketing - Learn SEO, PPC,...
SSC CGL, CPO, CHSL, GD Comprehensiv... All Levels English By Topline Coaching 3,999 5,499 27% off
Math Special Course for SSC CGL, CP... All Levels हिन्दी By Topline Coaching 999 1,499 33% off
Featured Courses
Popular Pages

Featured Courses

Introduction to Google Ads All Levels English By Digital World
FREE
5.0
NDA Exam online Course - 2021 Beginners Level English By CADETS PRIME DEFENCE 15,000 5.0
BESTSELLER
Reasoning Special by Parwez Sir for all Government... All Levels हिन्दी By Reasoning special by Parwez Alam
FREE
5.0
CAPF(AC) | Test Series All Levels English By Ajabs Academy Pvt Ltd
FREE
5.0
Free SEO training: SEO for beginners Beginners Level English By Digital Marketing - Learn SEO, PPC, SMO, SEM, Cont...
FREE
5.0
Ratio,Proportion and Partnerships for Bank and SSC... All Levels हिन्दी By logicalangle
FREE
5.0
NDA Exam Online Course 2021-2022 Beginners Level English By Sigma Classes 15,000 5.0
Free SEO Link Building Guide 2019 All Levels English By Digital Marketing - Learn SEO, PPC, SMO, SEM, Cont...
FREE
4.5
BESTSELLER
SSC CGL, CPO, CHSL, GD Comprehensive Course All Levels English By Topline Coaching 3,999 5.0

Popular Pages

SAT (Scholastic Assessment Test)

18 followers

Reasoning special by Parwez Alam

148 followers

NET

29 followers

Defence

106 followers

Study24x7

1218 followers

UPSC & State PSC

1008 followers

Henry Harvin

58 followers

SSC Preparation Strategies & Study Mater...

1541 followers

CBSE Study Materials

83 followers

Banking/IRDA

265 followers

Get the App

Download the Study24x7 App, so you can connect and collaborate.

study24x7
study24x7
Most Related Articles