What are functions3 5934
how to get the automatic backup of the database in the sql server4 31345
What command do we use to rename a db?5 8039
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 the purpose of UPDATE STATISTICS?2 9536
What is de-normalization and when do you do it?3 5206
Explain some DBCC commands?6 13527
What is the purpose of using COLLATE in a query?1 15881
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?