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)?


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?)


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


What is Lock table in SQL?


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.


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


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


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


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


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


whats new about truncate in sql server 2008?


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?


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


How to trouble shoot if unable to connect SQL Server


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