What are the different types of database compression introduced in sql server 2008? : sql server DBA
1109If 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
1022Post New DB Administration Questions
Where would you look for errors from the database engine?
how can you initialize log miner?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Which autogrowth database setting is good? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
how can you connect from 10g user to 11g user??
What is dbcc? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how can you enable flashback feature?
What purpose does the model database server? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
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?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA