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?


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?


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


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 ?


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


How to restore performance issues and how to check?


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


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.


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


where the connection string store in the database


How to trouble shoot if unable to connect SQL Server


1 01 101 01010


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.


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?


whats new about truncate in sql server 2008?


What is Lock table in SQL?


what is difference between view and Dip.


Tell about MOM Tool(Microsoft Operator Manager)?