1. Tell me your daily activities
2. If sql server installation fails at time
installation what will do
3. Where does the sql server installation log details
are stored
4. After the installation what will you do for memory
configuration
5. What is the difference between SQL max maximum
memory and AWE memory
6. How will you configure AWE memory
7. How will setup an email alert for the backup job
8. After the SQL installation what are the jobs will
you configure
9. What does –g mean in the sql startup parameter
10. What is the difference between Bulked log and Full
recovery model
11. What is the difference between mirroring and log
shipping
12. What are the steps to be followed before in-place
up gradation
13. After installing the patch the sql server does not
start and application team tells to rollback the
changes .In this scenario what will you do


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is data block and how to define data block size?

0 Answers  


Explain the various types of concurrency problem?

0 Answers  


What is attribute? : sql server analysis services, ssas

0 Answers  


Can we use custom code in ssrs?

0 Answers  


How can sql server instances be hidden?

0 Answers  






What does executeupdate return?

0 Answers  


What information is maintained within the msdb database?

0 Answers  


you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  


CREATE a table from another table

2 Answers  


Where are sql server user names and passwords stored in sql server?

0 Answers  


What is user defined datatypes and when you should go for them?

0 Answers  


What is default constraint in ms sql server?

0 Answers  


Categories