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 2773

Is index a datbase objects in sql server?

2 2587

What is Dedicated Administrator Connection in sql server 2005?

2 3485




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

2 2355

How many types of Joins in SQL Server 2005?

HCL, CarrizalSoft Technologies,

9 6413

What is Inner Join?

2 3000

What is Outter Join?

1 2148

How many types of Outer Joins?What are they?

1 2010




What is Left Outer Join?

2 2467

What is Right Outer Join?

2 2189

What is Full Outer Join?

3 3505

What is Cross Join

3 3649

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

3 4952

What is Self Join?

4 3560

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 13424


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Tell about MOM Tool(Microsoft Operator Manager)?

774


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

793


Call by value and call by reference in procedure and function, with NOCOPY.

239


What is Lock table in SQL?

364


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

861






what exactly sql injuction.how to overcome.....

1388


can any body tell me how to know the password of current user in sql server

990


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

912


what is package and it uses and how can u call a package

975


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

750


whats new about truncate in sql server 2008?

1398


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

874


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

1055


How to trouble shoot if unable to connect SQL Server

866


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1027