Answer Posted / swetha

No you can't call stored procedure inside triggers.

What are page splits?

1000

---

What are the common performance issues in sql server?

930

---

What is the difference between for auto and for nested?

1005

---

what are different types of raid configurations? : Sql server database administration

1065

---

How many levels of sp nesting are possible?

1029

---

What is the default sql server instance name?

1038

---

How to transfer data from a cursor to variables with a "fetch" statement?

1100

---

How will you make an attribute not process? : sql server analysis services, ssas

1094

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3877

---

How to start and end transact-sql statements?

1031

---

1 01 101 01010

2058

---

What is #table in sql server?

1046

---

Why can there be only one clustered index and not more than one?

1006

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2080

---

tell me the disaster recovery plan

2516

---