1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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 19184

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

Adea Solutions,

3 18926

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

 1 6880

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

 2 10889

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

 1 7429

Can XML be used to access data?

 2 3376

What is referential integrity and how is it achieved?

Adea Solutions,

1 10258

What is indexing?

AOL,

1692

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

 2 13574

Difference between server.transfer and server.execute method?

 2 11252

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

TCS, TPK,

2 10858

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

ASD Lab,

2 8305

What is a function? Give some example?

 3 9257

What is a stored procedure?

 3 5206

Difference between Function and Procedure-in general?

 6 13470

Un-Answered Questions { SQL Server }

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2310

Explain various On-Delete options in a DB table. Which is the default option?

1031

What happens on checkpoint?

697

Explain database normalization?

738

How to view existing indexes on an given table using sys.indexes?

712




Determine when an index is appropriate?

677

How can we remove orphan records from a table?

638

Explain triggers?

675

Explain having clause?

631

why would you call update statistics? : Sql server database administration

674

Do you know what are the restrictions that views have to follow?

732

How to get a list of columns in a view using the "sp_columns" stored procedure?

718

How to enforce security in sql server? : sql server security

720

How to use group functions in the select clause in ms sql server?

627

What is the filtered index?

694

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