SQL Interview Questions:
How to identify what hot fixes and service packs are installed.
How do identify and fix page corruption
What are trace flags, how many of them is in sql server
Emergency mode and suspect mode, how do you identify and fix it.
SQL Server is consuming 90 percent of memory how do you troubleshoot it.
Tempdb is full, what are steps you to take to prevent it
Tempdb is full, how do you freespace without shrinking it
what is missing indexes and unusable index, how to identify them and troubleshoot it
Difference between index online and reorganize index
10.Processor affinity and I/O affinity
11.what is heart beat and keep alive and is alive
12.what is the boot page in sql server
13.file architecture
14.what is active - active and active - passive in cluster
15.files and filegroup backups
16.SQL Server Architecture
17.Ghost Cleanup or Ghost Rows
18.what are missing indexes and unused indexes
19.what is TUF file and what happens if it gets lost
20.steps for failover in logshipping
21.can u use same backup and restore path after failovering in logshipping
22.Tail log backup and point in time recovery
23.steps for point in recovery if u database is crashed on wednesday afternoon how u perform it.
24.How to take log backup if the log is corrupted for a database or taking a log backup for a crashed
database. (Tail log backup and continue after error)
25.How do you verify whether Backup succeed or not. U need to use RESTORE VERIFY ..
26.How do you move tempdb files to another location.
27.Difference between Simple and Full recovery model
28.I have 32 bit system, and have 32 GB RAM, how much memory does it take, what options do we
required to be enabled to have max memory
29.what is the use of min memory setting in sql server
30.Difference between cluster index and non clustered index
31.what is update statistics, reoraganize index and rebuild index, and what is view to view it.
32.How to patch sql server cluster instance
33.what is Service packs and Hot fix.
34.When do you get orphan users in sql server and what is the command to find it.
35.what is the way to execute T SQL query across multiple instances at same time -- registered
servers.
36.How can locate sql server error log if the instance has crashed.
