SQL Server Interview Questions
Questions Answers Views Company eMail

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 2591

Is index a datbase objects in sql server?

2 2366

What is Dedicated Administrator Connection in sql server 2005?

2 3290




why SQL server is more used to store database rather than Access

2 2159

How many types of Joins in SQL Server 2005?

HCL, CarrizalSoft Technologies,

9 5998

What is Inner Join?

2 2782

What is Outter Join?

1 1954

How many types of Outer Joins?What are they?

1 1826




What is Left Outer Join?

2 2268

What is Right Outer Join?

2 1995

What is Full Outer Join?

3 3312

What is Cross Join

3 3332

Diff. b/w Full Outer Join And Cross Join?

3 4636

What is Self Join?

4 3303

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

Mphasis, Logitech,

1 12768


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is the query optimization statistics?

1177


If a stored procedure is taking a table data type, how it looks?

4560


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1096


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

793


how to take backup bcp out for a column in table in sql server?

804






What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1104


What is best institute to Learn DotNET And SQL in chennai?

912


If user is owning any SQL Objects, can we drop that user

812


Delete duplicate rows without using rowid.

134


whats the maximum size of view state??

892


Issues related in upgrading SQL Server 2000 to 2005 / 2008

719


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

889


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

834


You are doing log shipping due to some reasons it is failing. How you will proceed from there

770


Working with TLogs

640