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

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

HCL,

2 19853

What are cursors? Name four types of cursors and when each one would be applied?

Adea Solutions,

3 20142

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 7368

How do you load large data to the SQL server database?

2 11552

How do you check the performance of a query and how do you optimize it?

1 7851

Can XML be used to access data?

2 3939

What is referential integrity and how is it achieved?

Adea Solutions,

1 10781

What is indexing?

AOL,

2048

What is normalization and what are the different forms of normalizations?

2 14233

Difference between server.transfer and server.execute method?

2 11925

What is better - 2nd Normal form or 3rd normal form? Why?

TCS, TPK,

2 11591

Can we rewrite subqueries into simple select statements or with joins? Example?

ASD Lab,

2 9172

What is a function? Give some example?

3 10017

What is a stored procedure?

3 6140

Difference between Function and Procedure-in general?

6 14738

Un-Answered Questions { SQL Server }

What are commonly used mssql functions in php?

1015

What is federation member?

114

How to write a query with a left outer join in ms sql server?

934

What is sql server management studio? : sql server management studio

1026

How to create new tables with "select ... Into" statements in ms sql server?

937

How to find index size for each index on table?

973

What is policy based management (pbm)? : sql server database administration

940

What are the recovery models in sql server 2000?

929

Explain subquery and state its properties?

976

How many types of triggers in sql server?

979

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

902

Are semicolons required at the end of sql statements in sql server 2005?

939

explain the storage models of olap? : Sql server database administration

898

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2460

How to recreate an existing index in ms sql server?

1001

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