SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 2749

How do you fine the performance tunning?

Accenture,

2 5465

what is diffence between replicaion and logshipping?

1 2595




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

2 4966

When do you create cluster and noncluster index?

Satyam,

5 6212

how can do you the system monitoring?

1 5193

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

2 2743

How the data stores in a page?

1 2823




what are the problems in logshipping?

3 18513

How to tune a stored procedure?

6 12420

what is index seek and index scan?

2 9554

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

CSC, Intelligroup, ASD Lab,

9 58102

What about UPDATESTATISTICS ?

HCL, Intelligroup,

2 3939

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

2 3507

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

4 4773


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How can we call UDF(User Define Function) using C# code in ASP.net ?

4787


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., }

1100


How to restore performance issues and how to check?

899


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

1357


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2731






How do use Having,Group by,Group function in SQL?

721


where the connection string store in the database

877


How to trouble shoot if unable to connect SQL Server

826


1 01 101 01010

804


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.

1300


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1093


whats new about truncate in sql server 2008?

1358


What is Lock table in SQL?

327


what is difference between view and Dip.

1259


Tell about MOM Tool(Microsoft Operator Manager)?

734