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

What are the basic functions for master, msdb, model, tempdb and resource databases?

975

---

What is the difference between nvl and nvl2?

942

---

What is table value parameters (tvp)?

1090

---

Can sql servers linked to other servers like oracle?

938

---

Can you leave a union at any time?

1052

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1899

---

What does top operator do?

1010

---

what are acid properties? : Sql server database administration

984

---

Explain aggregate functions?

1067

---

Tell me what is the significance of null value and why should we avoid permitting null values?

973

---

Which autogrowth database setting is good?

1051

---

Explain what are the restrictions while creating batches in sql server?

1055

---

What is query and its types?

905

---

What is difference between group by and having?

938

---

What is #temp and @table variable in SQL server?

1078

---