Answer Posted / m.sivakumar

The SQLSERVR.EXE is located in binn directory of Sql server.

-m is used for starting SQL Server in single user mode.
-f is used to start the SQL Server in minimal configuration
mode.

What is it unwise to create wide clustered index keys?

951

---

Name few endpoints exposed by ssrs 2012?

343

---

Is foreign key a primary key?

976

---

How to return the second 5 rows in ms sql server?

1005

---

What is a raid and what are different types of raid configurations?

1200

---

How many columns can exist together per table?

1097

---

How you can change a cross join into an inner join?

908

---

What is partition in sql server?

972

---

How to convert a numeric expression from one data type to another?

930

---

How do we know if any query is retrieving a large amount of data or very little data?

916

---

How do you manipulate data?

848

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1024

---

how you can get the list of largest tables in a database? : Sql server administration

982

---

What is use of except clause? How it differs from not in clause?

970

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1008

---