SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

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 4419

Is index a datbase objects in sql server?

2 4880

What is Dedicated Administrator Connection in sql server 2005?

2 5469

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

2 4601

How many types of Joins in SQL Server 2005?

CarrizalSoft Technologies, HCL,

9 11972

What is Inner Join?

2 5142

What is Outter Join?

1 3957

How many types of Outer Joins?What are they?

1 3756

What is Left Outer Join?

2 4471

What is Right Outer Join?

2 4548

What is Full Outer Join?

3 6083

What is Cross Join

3 6523

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

3 7451

What is Self Join?

4 6583

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?

Logitech, Mphasis,

1 16560

Un-Answered Questions { SQL Server }

What are subquery and its properties?

1044

What is faster join or union?

1200

How to delete duplicate rows in sql server?

1101

What are the limitations/drawbacks or ssrs 2008 r2?

139

Tell me what do you understand by a view? What does the with check option clause for a view do?

1019

How to drop an existing schema in ms sql server?

1094

What are the advantages of user defined function?

980

What is function of ROLLUP ?

1080

Will the writetext statement activate a trigger?

1089

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1074

Explain Geography datatype in SQL Server

1127

How can you fetch alternate records from a table?

958

What is a Join and explain its types?

1099

Can you explain various data region available in ssrs with their use?

970

How do we synchronize On-Premise SQL server with SQL Azure?

122

For More Un-Answered { SQL Server } Questions Click Here