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
1151Post New DB Administration Questions
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
How can you control the amount of free space in your index pages? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to start SQL Server in minimal configuration mode?
what are the differences of where and if in SAS?
What the different types of replication and why are they used? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Due 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
What the different topologies in which replication can be configured? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is dbcc? : sql server DBA
how does an oracle clusterware manage crs resources?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Where would you look for errors from the database engine?