What are the different types of database compression introduced in sql server 2008? : sql server DBA
558If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
550Post New DB Administration Questions
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
how can you implement fine-grained auditing?
what is the use of recording information about current session?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What authentication modes does sql server support? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you connect from 10g user to 11g user??
how to restore files with rman?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
How would you best determine why your MVIEW couldn't FAST REFRESH?
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.
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?