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 19944

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

Adea Solutions,

3 20276

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

1 7439

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

2 11655

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

1 7908

Can XML be used to access data?

2 4008

What is referential integrity and how is it achieved?

Adea Solutions,

1 10844

What is indexing?

AOL,

2108

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

2 14324

Difference between server.transfer and server.execute method?

2 12008

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

TCS, TPK,

2 11695

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

ASD Lab,

2 9262

What is a function? Give some example?

3 10137

What is a stored procedure?

3 6284

Difference between Function and Procedure-in general?

6 14944

Un-Answered Questions { SQL Server }

How to find the second highest salary of an employee?

1167

Can sql server 2016 run on windows 7?

910

What is database replication? What are the different types of replication you can set up in sql server?

954

What do you understand by intent locks?

1002

How to list all user names in a database?

1047

How to change the password of a login name in ms sql server?

1008

How to list all columns in a table using odbc_columns()?

971

What is the dbcc command and why is it used?

1044

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

953

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2385

what are the disadvantages of cursors? : Sql server database administration

1027

What are commit and rollback in sql?

1117

What triggers long term care?

1022

Explain the usage of floor function in sql server.

956

How do I create a partition table in sql server?

1105

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