1. What are Recovery Model?
2.Can i create 2 MDF's?
3.CPU Bottleneck?
4.How to handle Dead Lock and Blocking?
5.What Update Statistics will do?
6.Query Governer?
7.Features of Sql Server 2005  comparing 2000?
8.Security Feature? XML Data Type?
9.What is DAC?How you use it?
10.How work bulk log recovery Model?when bulk operation loaded?
11.Buffer hit ratio?
12.How you getting issues?
13.Which Moniter tool used for getting tickets?
14.What type of alerts you are getting?
15.What is rebuild and reorg?
16.How you checking health of the Data bases?
17.What type of DMV's are you using in real time?
18.What are used in you maintained plan?
19.What is Boot.ini?




1.Migration steps?
2.How to checking store procedure performace?
3.How many types of replication?
4.Suspect Mode Reasons?
5.Difference between SSIS & DTS?
6.How to monitor 100 servers at a time in your company?






1.Application Role?What are Server Roles?Data base Roles?
2.What is Service Account?What is purpose of in Real time?
3.Back up Strategy?
4.What Minimally logged in Bulk Logged recovery model?
5.Log shipping,Mirroring configuration steps?
6.What is clustering?what contains in Heart Beat Signal?CUI to
getcluster nodes involved in clustering?How to remove node?
7.I shrink&truncate the log file what changes occur in secondary
database in log shipping?
8.I restore back up on secondary server after half on hour i enable
log shipping, How to lhalf on hour transaction into secondary server
data base?
9.Can i take full backup & T-Log of log shipping configured data base?
10.How to get data base size?
11.In log shipping my primary db in suspect mode, how to take tail log
back up?What is Tail log back up?
12.What is collation?How to use in real time?examples/
13.what is logical and physical architecture in sql server?
14.Which tabel store back up information?
15.Did you see Size of log file more than data file size?






1.What is Default Port No?What is That?Can i change Port no?How to
change Port no?

1. What are the perfmon counters used to check memory utilization.

2. Which DMV's we can use to check perfmon counters.

3. Which DMFs can we use to check the complete command running in a session.

4. Which exe file can be used to trace the server actitivites.

5. Statistics - How to update on a particular table index.

6. Memory configuration.

If there is 16GB RAM, how can we make the server to use min 12 and max 14.

Lock pages in memory

7. How to improve the performance of Log Shipping.

8. How to move system dbs

* TempDb

* master

9. Execution plans

10.Why use DAC? How to connect?

11.Regular issues?