SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?


3 7585

What are functions

3 5934

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

4 31345

What command do we use to rename a db?

5 8039

What are the four main query statements?


7 14249

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

3 11887

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

2 16646

What is SQL server agent?

HCL, SAP Labs,

2 5772

What is the purpose of UPDATE STATISTICS?

2 9536

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

3 5206

Difference between Function and Stored Procedure?

C1 India,

9 14293

What is data integrity? Explain constraints?


1 21362

Explain some DBCC commands?

6 13527

What are tasks?


3 7844

What is the purpose of using COLLATE in a query?

1 15881

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?


tell me the disaster recovery plan


ow to bring suspect mode datbase online from scratch


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.


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


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


application server is slow what may be the problem


Explain Capacity planning to create a database? and how to monitor it?


what is the sql equivaent of the dataset relation object ?


what is difference between view and Dip.


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?


System variable and temporary variables


What is the difference between NOROW and LOCKROW?