SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?


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?


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?


1 21160

Explain some DBCC commands?

6 13364

What are tasks?


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?


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.


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


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.


how can u get last observation in an unknown dataset ?


whats the maximum size of view state??


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?


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


What is data modeling and Reterminal integrity?


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


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


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?


tell me the disaster recovery plan


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


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