SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

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?

Wipro,

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?

Thinksoft,

1 21362

Explain some DBCC commands?

6 13527

What are tasks?

Wipro,

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.

1618


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?

864


tell me the disaster recovery plan

1285


ow to bring suspect mode datbase online from scratch

685


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

678






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.

665


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

877


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

656


application server is slow what may be the problem

1084


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

2804


what is the sql equivaent of the dataset relation object ?

844


what is difference between view and Dip.

1206


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?

781


System variable and temporary variables

980


What is the difference between NOROW and LOCKROW?

1293