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 8380

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

1 2731

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

3 3569




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 2455

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

TCS,

3 6159

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

1 2718

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

Wipro,

10 10953

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

HCL,

1 7896




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

HCL,

1 5398

What is blocking and how would you troubleshoot it?

HCL,

3 4458

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

HCL,

3 7485

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

HCL,

1 5918

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

HCL,

2 5948

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

HCL,

3 11213

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

HCL,

2 7216


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

871


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

683


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.

1235


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

914


Issues related in upgrading SQL Server 2000 to 2005 / 2008

740






optimization techinques

1277


If a stored procedure is taking a table data type, how it looks?

4588


how many no of arguments can be passed in procedures and functions

3451


How do you Implement SSIS Packages in your Project?

809


application server is slow what may be the problem

1065


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

334


Call by value and call by reference in procedure and function, with NOCOPY.

122


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

4175


What is the difference between NOROW and LOCKROW?

1233


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

928