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 19082

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

Adea Solutions,

3 18833

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

 1 6828

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

 2 10794

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

 1 7365

Can XML be used to access data?

 2 3288

What is referential integrity and how is it achieved?

Adea Solutions,

1 10194

What is indexing?

AOL,

1659

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

 2 13493

Difference between server.transfer and server.execute method?

 2 11166

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

TCS, TPK,

2 10745

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

ASD Lab,

2 8202

What is a function? Give some example?

 3 9171

What is a stored procedure?

 3 5140

Difference between Function and Procedure-in general?

 6 13350

Un-Answered Questions { SQL Server }

What does it mean if @@cursor_row returns a negative number?

611

What are secondary xml indexes?

644

Explain what are the events recorded in a transaction log?

616

Which database stores information about replication?

609

What is equi join with example?

630




What is data source view or dsv? : sql server analysis services, ssas

613

What is join query?

564

Do you know query execution plan?

647

What is Command line parameters in PLSQL.?

640

What is the difference between function and stored procedure in sql server?

550

How do you create a data source?

545

How to apply cascading referential integrity in place of triggers?

635

What happens if you delete a table that is used by a view?

631

How do I run sql server 2014?

576

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

603

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