Answer / swapna

Sql Server can be started from command line, using the
Sqlserver.exe. This exe has some very important parameters
with which a Dba should be familiar with.

-m is used for starting Sql Server in single user mode and -
f is used to start the Sql Server in minimal confuguration
mode

Answer / sqlserverbuddy

1. STOP the SQL Server Service(Management Studio or Service)
2. Step into Root directory of the SQL server Instance
(Default or Named Instance)
3. Enter as given below for Default Instance
sqlservr -m
4. Enter as given below for Named Instance (MyServer)
sqlservr -m -s MyServer
5. Don't close the DOS screen which processing internal
activities.
6. Open the SQL Server management studio and Proceed

Answer / rahul

1) type cmd in rum
2) Stop the Server from configuration manager first and
then In Command Window, Type net start mssqlserver -m for
starting the Service in single user mode.
3) Type net start mssqlserver -f to start the Server in
minimal configration.

what are the different ways to return the rowcount of a table?

0 Answers   Microsoft,

---

What is trace flag in sql server?

0 Answers  

---

What is standby servers? Explain types of standby servers.

0 Answers  

---

What is a covered index?

0 Answers  

---

How to rebuild master databse?

0 Answers  

---

Explain unique key in sql server?

0 Answers  

---

What is merge statement?

0 Answers  

---

What are sparse columns?

0 Answers  

---

What is data compression? : sql server database administration

0 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

---

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

---

Where are full-text indexes stored?

0 Answers  

---