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 15783

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

Adea Solutions,

3 16201

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

1 5452




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

2 9009

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

1 5972

Can XML be used to access data?

2 1768

What is referential integrity and how is it achieved?

Adea Solutions,

1 8185

What is indexing?

AOL,

882




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

2 11452

Difference between server.transfer and server.execute method?

2 9700

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

TCS, TPK,

2 8447

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

ASD Lab,

2 6105

What is a function? Give some example?

3 7301

What is a stored procedure?

3 3107

Difference between Function and Procedure-in general?

6 10738


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

871


Does any body please help me what question's have asked for SSRS in the interview?

815


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1124


how to do partition in sqlserver

1279


plss anybody specify tha constrian management system in dbms

788






What is best institute to Learn DotNET And SQL in chennai?

936


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

782


how can u get last observation in an unknown dataset ?

1106


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

334


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

899


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

749


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

772


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1544


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

928


whats the maximum size of view state??

914