Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 3264

How do you fine the performance tunning?

Accenture,

2 6326

what is diffence between replicaion and logshipping?

1 2981

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

2 5942

When do you create cluster and noncluster index?

Satyam,

5 7070

how can do you the system monitoring?

1 5685

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

2 3256

How the data stores in a page?

1 3489

what are the problems in logshipping?

3 19709

How to tune a stored procedure?

6 13574

what is index seek and index scan?

2 10284

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

ASD Lab, CSC, Intelligroup,

9 60838

What about UPDATESTATISTICS ?

HCL, Intelligroup,

2 4482

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

2 4095

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

4 5689







Un-Answered Questions { SQL Server }

How is table type constraint applied to a table?

205


What is the difference between locking and multi-versioning?

196


Do you know what is a linked server in sql server?

214


What is the recovery model? List the types of recovery model available in sql server?

192


Which table keeps information about stored procedures?

192






How optimize sql query with multiple joins in sql server?

151


What are constraints in microsoft sql server?

195


What happens if date-only values are provided as date and time literals?

184


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1626


Explain linked server in sql?

271


Indexes are updated automatically is the full-text index also updated automatically?

193


Explain datetimeoffset data type in sal server 2008?

172


Explain syntax for dropping triggers?

180


Is sql server free?

182


Explain the different types of joins?

194