Interview Questions
-
Steps involved in ugrade SQL Server to a new version. (8:29)
-
Managing multiple SQL Server instances (4:33)
-
Creating a new database (6:58)
-
Recovery Models (5:43)
-
Backup and Restore (7:03)
-
Concept of Indexes (11:37)
-
Log Shipping (6:11)
-
System Databases (3:39)
-
Query Optimization (3:59)
-
SQL Agent Jobs (5:50)
-
Index Fragmentation (7:24)
-
Transaction Log (6:07)
-
Webservice Calls (3:50)
-
Performance, tools and technique
-
Normalization (8:01)
-
Profiler and Extended Events (1:42)
-
Role and Configuration of TempDB
-
Database Maintenance (4:30)
-
Deadlocks (4:58)
-
Database Mail
-
Database Snapshots (2:57)
-
Replication Types and Concepts (4:49)
-
JOIN Types (7:09)
-
Stored Procedures and Functions
-
Temp Tables and Table Variables
-
What is Sharding? (4:27)
Non-Technical Questions
Summary
