SQL Server Interview Questions
Questions Answers Views Company eMail

what is the query and condition to delete datas in sql server.

2 4006

How do you fine the performance tunning?

Accenture,

2 7433

what is diffence between replicaion and logshipping?

1 3476

what is physical sort data and logical sort data in index?

2 7312

When do you create cluster and noncluster index?

Satyam,

5 8454

how can do you the system monitoring?

1 6275

what is the Enterprise manager(2000) and management studio (2005)?

2 3982

How the data stores in a page?

1 4506

what are the problems in logshipping?

3 20856

How to tune a stored procedure?

6 15138

what is index seek and index scan?

2 11136

What is the difference between IN and EXISTS operators in SQL Server?

ASD Lab, CSC, Intelligroup,

9 63411

What about UPDATESTATISTICS ?

HCL, Intelligroup,

2 5289

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 4860

can you any body tell me the difference between candidate key and primary key

4 6793


Un-Answered Questions { SQL Server }

What is the purpose of linked server configuration in sql server?

542


Explain triggers?

550


How to delete database objects with "drop" statements in ms sql server?

585


How to create hyperlink from returned sql query ?

612


What is the osql utility?

531






Write down the syntax and an example for create, rename and delete index?

524


What options are available to audit login activity? : sql server security

627


What is replication and database mirroring?

568


How can a user-defined datatype be created?

532


How many databases Microsoft SQL server provides?

600


Why transaction is important?

555


Does partitioning improve performance?

474


How dts is used to extract, transform and consolidate data?

585


How to rebuild all indexes on a single table?

576


What are built in functions?

568