Answer Posted / sruthi

Index created on view is called as indexed view or
materialised view.
To create index on a view we should create a view
with "schemabinding"
eg:
create view v1 with schemabinding as
select empno,ename from dbo.emp
---
while creating view with schema binding refer to table by
default owner
---
now create index on that view
--
create clustered index i1 on v1(empno)
--
now this is called as indexed view

Explain about temporary stored procedure?

936

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

915

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1327

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1007

---

Explain the Ways to improve the performance of a sql azure database?

80

---

Explain transaction server explicit transaction?

879

---

What is index in an assignment?

894

---

What is pivot and unpivot?

978

---

Why use triggers?

969

---

How to write character string constants or literals in ms sql server?

960

---

What is the recommended total size of your memory optimized tables?

912

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

972

---

Explain the difference between control flow and data flow?

933

---

What is history table in sql server?

896

---

What is a trigger and its types?

929

---