SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 2598

How do you fine the performance tunning?

Accenture,

2 5290

what is diffence between replicaion and logshipping?

1 2476




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

2 4736

When do you create cluster and noncluster index?

Satyam,

5 5991

how can do you the system monitoring?

1 4989

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

2 2622

How the data stores in a page?

1 2637




what are the problems in logshipping?

3 18148

How to tune a stored procedure?

6 12211

what is index seek and index scan?

2 9361

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

CSC, Intelligroup, ASD Lab,

9 57472

What about UPDATESTATISTICS ?

HCL, Intelligroup,

2 3810

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

2 3387

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

4 4560


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1472


Delete duplicate rows without using rowid.

157


How to convert a table data in XML format in sql server?

1370


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1544


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

280






How to trouble shoot if unable to connect SQL Server

744


ow to bring suspect mode datbase online from scratch

663


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


on line cluster can we make if yes tell me the procedure

814


role of sql sever 2005 in database rather than any other database

856


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

3452


What is data modeling and Reterminal integrity?

633


what is the sql equivaent of the dataset relation object ?

808


Explain Capacity planning to create a database? and how to monitor it?

2742


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

672