Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



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 17585

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

Adea Solutions,

3 16978

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

1 5961

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

2 9728

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

1 6591

Can XML be used to access data?

2 2290

What is referential integrity and how is it achieved?

Adea Solutions,

1 9210

What is indexing?

AOL,

1191

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

2 12471

Difference between server.transfer and server.execute method?

2 10245

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

TCS, TPK,

2 9358

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

ASD Lab,

2 6984

What is a function? Give some example?

3 7907

What is a stored procedure?

3 3779

Difference between Function and Procedure-in general?

6 11612







Un-Answered Questions { SQL Server }

What is BLOCK statements in SQL?

191


How will you know when statistics on a table are obsolete?

152


What are the tables in sql?

170


How can you hide the sql server instances?

133


What is temporal data type?

120






What is the purpose of object explorer and its features? : sql server management studio

146


Please illustrate physical database architecture? : SQL Server Architecture

133


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

981


Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

138


What are the options which must be set to allow the usage of optimistic models?

135


when would you go for denormalization? : Sql server database administration

121


what changed between the previous version of sql server and the current version? : Sql server database administration

123


What are the types of dml?

108


What is sql sandbox in sql server?

169


New concepts of sql server 2005 use in your project.

1505