SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?


3 6835

What are functions

3 5446

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

4 31006

What command do we use to rename a db?

5 7706

What are the four main query statements?


7 13522

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

3 11637

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

2 16182

What is SQL server agent?

HCL, SAP Labs,

2 5429

What is the purpose of UPDATE STATISTICS?

2 9104

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

3 4944

Difference between Function and Stored Procedure?

C1 India,

9 13872

What is data integrity? Explain constraints?


1 20821

Explain some DBCC commands?

6 13053

What are tasks?


3 7462

What is the purpose of using COLLATE in a query?

1 15510

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

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., }


If a stored procedure is taking a table data type, how it looks?


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


If we delete pack Spec what will be the status of pack Body ?


Why do you want to join software field as you have done your BE in Electronics?


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible


You are doing log shipping due to some reasons it is failing. How you will proceed from there


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


How can we call UDF(User Define Function) using C# code in ASP.net ?


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.


Tell about MOM Tool(Microsoft Operator Manager)?


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions


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?


What is the difference between NOROW and LOCKROW?


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?