Answer Posted / hanumathkumar

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

Give me a SQL Query to find out the second largest company?

1150

---

What is data source view or dsv? : sql server analysis services, ssas

984

---

Tell me what is difference between view and materialized view?

920

---

What is the difference between for trigger and after trigger?

1085

---

What are functions in the sql server?

1188

---

What are the advantages of having an index on the sql server?

912

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1111

---

What is tabulation?

936

---

What do you understand by physical_only option in dbcc checkdb?

966

---

How to use linked server?

1165

---

What does asynchronous call backs means?

1129

---

Do comments need to go in a special place in sql server 2005?

844

---

what type of index will get created after executing the above statement? : Sql server database administration

961

---

how can a database be repaired? : Sql server administration

956

---

Why should you use or avoid select * statements?

1002

---