SQL Server Interview Questions
Questions Answers Views Company eMail

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 8222

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 2657

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 3481

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 2336

What is the system function to get the current user's user id?


3 6020

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 2657

What's the difference between a primary key and a unique key?


10 10680

What are the steps you will take to improve performance of a poor performing query?


1 7736

What are the steps you will take, if you are tasked with securing an SQL Server?


1 5262

What is blocking and how would you troubleshoot it?


3 4300

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?


3 7302

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?


1 5796

What are statistics, under what circumstances they go out of date, how do you update them?


2 5793

What are the different ways of moving data/databases between servers and databases in SQL Server?


3 11019

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?


2 7049

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

You are doing log shipping due to some reasons it is failing. How you will proceed from there


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?


which backup strategy you are following at ur company


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?


query processing


How to restore performance issues and how to check?


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


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?


what are the critical issues you have resloved in your company


How much memory that we are using in Logshipping Concept?


How retrieve field names from the table in SQL through JAVA code?


your distribution database is full what will u do


whats the maximum size of view state??