SQL Server DBA Interview Questions and Answers Videos – Overview
# What is locking in SQL Server
# Is it best practice to have Auto Shrink enable on Database
# Can Instance Level Collation be different from Database Collation
# What is the difference between default and Named Instance of SQL Server?
# What is replication, Types of replication and when to use each type
# Can you have different Collation on different Database
# How many SQL Server Instances can be installed on one machine
# What is Transaction Undo File (TUF)
# What is Link Server in SQL Server
# When should we update Statistics on SQL Server Database and why
# What is difference between Backup Restore and Detach Attach Database
# What is Database Engine Tuning Advisor and where do you have used it
# How to Shrink Database Log file in SQL Server
# Migration strategy For SQL Server 2008 to SQL Server 2012
How to find space allocated to Database log file
How to find version and Edition of SQL Server Instance
How to Assign or configure memory in SQL Server instance
How to script all SQL Server Agent Jobs
How to trace deadlock information in SQL Server
21-SQL Server DBA Interview | What strategies you should adopt to keep the Tran log reasonable
23-SQL Server DBA Interview | What is the difference between Full backup and Differential backup
25-SQL Server DBA Interview Questions | What are two Athentication modes in SQL Server
27-SQL Server DBA Interview | How would you find out that How long SQL Server Instance is running
28-SQL How would you find out how many transactions per second SQL Server Instance is performing
29-SQL Server Interview Questions | How would you find orphan users and how would you fix them
30-SQLHow would you find currently running queries on SQL Server Instance
31-SQL How to create maintenance plan that will backup all databases Full backup in SQL Server
32-SQL Server DBA Interview Questions | How to change SQL server Agent Job history Retention Period
33-SQL Server DBA Interview Questions | How to change Server Authentication modes in SQL Server
34-SQL Server Interview | How to approach analysis if sql server started running really slow
35-SQL You need to find JOB EXECUTION history for last ten days, Where will you search for that
36-SQL Server DBA Interview Questions | How to Debug Permission Issue for user in SQL Server
37-SQL Server DBA Interview | Which built in tool you have used to Monitor SQL Server activity
39-SQL - What is the differences b/w differential DATABASE BACKUP and Transaction log backup
40-SQL Server Interview Question | What is the difference Between Index Rebuild and Index Reorganize
42-SQL DBA Interview | What are the steps to Restore a SQL Server Database to a Point in Time
43-SQL Server | What are the important points you consider before coming up with Backup strategy
44-SQL Server DBA Interview Questions and Answers | What are the differences between DMV's and DMF's
45-SQL Server DBA Interview | What are DDL Triggers & Where and why have you created them
46-SQL Server Interview Question | How would you shrink the tempdb database in SQL Server
47-SQL Server DBA Interview Questions | How would you identify table level locks in SQL Server
49-SQL Explain steps to perform Table Partitioning and what are the best practices to do so
50-SQL How to Configure existing standalone sql server named instance if Machine names changes
51-SQL Server Interview Question and Answer | How to change Sql Server service account
52-SQL Server DBA Interview Questions| Does SQL Server allow duplicate indexes
53-SQL Server | Replication Error, can't connect to actual server, @@servername returns Null
54-SQL Server | What are the best practice to configure TempDB in SQL Server
55-SQL Server Interview Questions and Answers | What are Trace Flags in SQL Server
56-SQL Server DBA Interview Questions & Answers | What is index fragmentation
57-SQL Server Interview | What is Latch, What is the difference between Latch and Lock in SQL Server
58-SQL Server Interview Questions & Answers | What is Service Account in SQL Server
59-SQL Server Interview | What is the difference between 64 Bit and 32 Bit releases of SQL Server
60-SQL Server Interview | What is the difference between Physical and Logical Reads in SQL Server
61-SQL Server | What is the difference between shrinking and truncating database log file
62-SQL Server Interview Questions & Answers | Can you bring replicated database offline
64-SQL Can you schedule replication And under what circumstances do we schedule replication
65-SQL Server DBA Interview Questions and Answers | How would drop replicated database
66-SQL Server DBA Interview Questions | How would you add new tables in existing replication
67-SQL Server DBA Interview Questions | Under what circumstances will you re initialize replication
68-SQL Server DBA Interview Questions & Answers | Under what scenarios would you use log shipping
69-SQL Server DBA Interview Questions and Answers | What exactly merge is replication
70-SQL Server Interview Questions | What is orphan replication And how would you cleanup replication
71-SQL Server DBA Interview Questions & Answer | What is re initializing means in replication
72-SQL Server Interview Questions | What is the difference between log shipping and replication
73-SQL Server DBA Interview Questions & Answers | When do we use snapshot replication
75-SQL Server | Your team needs to know if replication breaks or fails, what exactly would you do
76-SQL Server DBA Interview Questions & Answers | Why do we use SQL server Browsing services
77-SQL Server Interview Questions and Answers | Why do we use clustering
78-SQL What is the difference between cluster mode and standard mode sql server installation
79-SQL Server Interview Questions and Answers | What is SQL Server Clustering
80-SQL Server Interview | What is recommended configuration of SQL server browsing services
81-SQL Server Interview Questions and Answers | What is cluster aware
82-SQL Server DBA Interview Questions and Answers | What is Auto failover of primary replica in AG
83-SQL Server DBA Interview | What is active active and active Passive cluster
84-SQL Server DBA Interview Questions | What does read intent settings mean in AG
85-SQL Server DBA Interview Questions & Answers | What does in-memory Stored Procedure mean?
86-SQL What are the issues using primary or secondary replica as your main distributor
87-SQL Sever DBA Interview Questions | What are SQL server Browsing services
88-SQL Server DBA Interview Questions | How would you find out if SQL server failover happened
89-SQL Server DBA Interview Questions & Answers | How to add a resource in existing cluster
90-SQL Server DBA Interview Questions | Can you setup replication with AlwaysOn
91-SQL Applications can't connect to SQL Server after failover, what could be the issue
92-SQL Server DBA Interview Questions & Answers | Why do we use Listener in Availability Group
93-SQL Server DBA Interview | What is Secondary replica in AlwaysOn Availability Group
94-SQL Server DBA Interview | What is primary replica in AlwaysOn Availability Group
95-SQL What is new in SQL server 2012 that's not available in previous versions of SQL servers
96-SQL Server DBA Interview Questions and Answers | What is Listener in AG
97-SQL Server DBA Interview Questions & Answers| What is Availability Group
98-SQL Server DBA Interview Questions | What is AlwaysOn in sql server 2012
99-SQL Server Interview Questions and Answers | What causes Availability Group to fail over
100-SQL Server DBA Interview | What are some of the advantages of AlwaysOn feature
