What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
1094What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
1102What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
1028When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
980Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
1010What is the difference between dropping a database and taking a database offline? : sql server DBA
1050Post New DB Administration Questions
What is the default port no on which sql server listens? : sql server DBA
what are the types of connection load-balancing?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you initialize log miner?
Where do you find the default index fill factor and how to change it? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Why does Oracle not permit the use of PCTUSED with indexes?
what is the use of ocr?
how can you record information about current session?
what are the differences of where and if in SAS?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the different types of indexes available in sql server? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.