SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 7962

What are functions

3 6237

how to get the automatic backup of the database in the sql server

4 31543




What command do we use to rename a db?

5 8229

What are the four main query statements?

Wipro,

7 14622

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 12023

What is the STUFF function and how does it differ from the REPLACE function?

2 16893

What is SQL server agent?

HCL, SAP Labs,

2 5993




What is the purpose of UPDATE STATISTICS?

2 9788

What is de-normalization and when do you do it?

3 5353

Difference between Function and Stored Procedure?

C1 India,

9 14530

What is data integrity? Explain constraints?

Thinksoft,

1 21651

Explain some DBCC commands?

6 13795

What are tasks?

Wipro,

3 8063

What is the purpose of using COLLATE in a query?

1 16076


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Scalability, Availability, Integration with internet, etc.)?

1711


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

425


your distribution database is full what will u do

1008


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.

753


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1100






what is isolation level at dead lock?

1064


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

912


SQL Server Architecture ?

1186


where the connection string store in the database

878


Issues related in upgrading SQL Server 2000 to 2005 / 2008

837


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1403


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.

1629


optimization techinques

1412


How to restore performance issues and how to check?

899


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

711