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
1199Post New DB Administration Questions
What is the default port no on which sql server listens? : sql server DBA
how to restore files with rman?
Why does Oracle not permit the use of PCTUSED with indexes?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is replication? : sql server DBA
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
how can you process messages in order asynchronously?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how can you connect from 10g user to 11g user??
What is fill factor? : sql server DBA
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
What would you do with an "in-doubt" distributed transaction?
Why would you use sql agent? : sql server DBA
How to start SQL Server in minimal configuration mode?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?