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 2555

Is index a datbase objects in sql server?

2 2320

What is Dedicated Administrator Connection in sql server 2005?

2 3249

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

2 2112

How many types of Joins in SQL Server 2005?

HCL, CarrizalSoft Technologies,

9 5925

What is Inner Join?

2 2725

What is Outter Join?

1 1920

How many types of Outer Joins?What are they?

1 1792

What is Left Outer Join?

2 2211

What is Right Outer Join?

2 1947

What is Full Outer Join?

3 3256

What is Cross Join

3 3259

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

3 4552

What is Self Join?

4 3244

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 12596

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

Why we need to use secondry database file? though, we can do same work using primary database file also.


what is isolation level at dead lock?


tell me the disaster recovery plan


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


If we delete pack Spec what will be the status of pack Body ?


what are the Prerequisites for Replication?


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


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


How to trouble shoot if unable to connect SQL Server


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?


ow to bring suspect mode datbase online from scratch


SQL Server Architecture ?


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks


how many no of arguments can be passed in procedures and functions


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