SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 7390

What are functions

3 5766

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

4 31246




What command do we use to rename a db?

5 7933

What are the four main query statements?

Wipro,

7 14041

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

3 11816

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

2 16512

What is SQL server agent?

HCL, SAP Labs,

2 5669




What is the purpose of UPDATE STATISTICS?

2 9414

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

3 5120

Difference between Function and Stored Procedure?

C1 India,

9 14170

What is data integrity? Explain constraints?

Thinksoft,

1 21160

Explain some DBCC commands?

6 13364

What are tasks?

Wipro,

3 7725

What is the purpose of using COLLATE in a query?

1 15775


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4723


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


last function used in MS Access to convert sql what function will use in sql

827


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.

684


how can u get last observation in an unknown dataset ?

1107






whats the maximum size of view state??

914


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1222


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

915


What is data modeling and Reterminal integrity?

633


If user is owning any SQL Objects, can we drop that user

830


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

772


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1020


tell me the disaster recovery plan

1261


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1118


Why we need to use secondry database file? though, we can do same work using primary database file also.

4176