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.

what is asm?

1005

---

What are the commands used in dcl? : sql server DBA

1009

---

which background process invoke at the time of upgradation tell me???

2667

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

962

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1018

---

What is a system database and what is a user database? : sql server DBA

1127

---

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

943

---

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.

1674

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2578

---

What is fill factor? : sql server DBA

1187

---

What are the different sql server versions you have worked on? : sql server DBA

970

---

what are the performance views in an oracle rac environment?

1008

---

What are statistics, under what circumstances they go out of date, how do you update them?

2204

---

What is transparent data encryption? : sql server DBA

1131

---

how can you connect from 10g user to 11g user??

2069

---