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 8463

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

1 2780

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

3 3631




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 2496

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

TCS,

3 6225

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

1 2765

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

Wipro,

10 11032

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

HCL,

1 7961




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

HCL,

1 5463

What is blocking and how would you troubleshoot it?

HCL,

3 4525

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

HCL,

3 7568

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

HCL,

1 5971

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

HCL,

2 6011

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

HCL,

3 11283

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

HCL,

2 7302


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

940


application server is slow what may be the problem

1084


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1300


tell me the disaster recovery plan

1285


how to take backup bcp out for a column in table in sql server?

854






your distribution database is full what will u do

956


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

818


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

1333


plss anybody specify tha constrian management system in dbms

821


which backup strategy you are following at ur company

993


Why we need to use secondry database file? though, we can do same work using primary database file also.

4215


wat wil hapn if we give the both read and deny read permission to user?

931


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1061


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

863


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

936