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 the default port no on which sql server listens? : sql server DBA

1212

---

What are the steps you will take to improve performance of a poor performing query?

2897

---

what is the role of dip user in our database?

2461

---

how can you enable flashback feature?

1006

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2036

---

What are the operating modes in which database mirroring runs? : sql server DBA

1237

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1179

---

What is a correlated sub-query? : sql server DBA

1154

---

what do you understand by flashback feature of oracle?

1042

---

What is the importance of a recovery model? : sql server DBA

1080

---

what is a crs resource?

1236

---

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?

2145

---

how can a session indicate its interest in receiving alerts?

1091

---

Why would you call update statistics? : sql server DBA

1039

---

what is a user-defined lock?

1137

---