Answer Posted / 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

Explain the types of indexes.

1193

---

What is the difference between executequery () and executeupdate ()?

1020

---

How to make a remote connection in a database?

962

---

How many columns can we include on clustered index ?

973

---

Explain about nested stored procedure?

1019

---

What does it mean to invest in the index?

954

---

What is sqlcmd?

1033

---

How to view existing indexes on an given table using sys.indexes?

1081

---

What is attribute? : sql server analysis services, ssas

1012

---

Explain different types of locks in sql server.

1066

---

What are various ways to enhance the ssrs report?

974

---

how you can configure a running aggregate in SSRS?

188

---

Tell me when is the update_statistics command used?

1095

---

What is the difference between dbcc indexdefrag and dbcc reindex?

977

---

What is the purpose of forms?

946

---