Answer Posted / santhosh

In a Command Prompt window, you can start the SQL server in
minimal configuration mode by typing: sqlservr -c -f

This command also starts the SQL server in single-user mode.
Also, the server will not run any startup stored procedures.
Additionally, when you start the SQL server in minimum
configuration mode, then SQL Server automatically sets the
size of tempdb to 2 MB on its default device. You must then
manually increase the size of tempdb as necessary.

Where would you look for errors from the database engine?

2791

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1920

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

937

---

How can you control the amount of free space in your index pages? : sql server DBA

1232

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4383

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2060

---

What is the default fill factor value? : sql server DBA

1058

---

How do you trace the traffic hitting a sql server? : sql server DBA

1464

---

What the different topologies in which replication can be configured? : sql server DBA

1179

---

how can you record information about current session?

976

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2511

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1022

---

how can you initialize log miner?

1084

---

how does an oracle clusterware manage crs resources?

1025

---

what is ora 24313?what is the procedure to exclude that error?

2518

---