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 key constraints?

958

---

What is Replication?

1025

---

What are the steps you must follow to hide sql server instances?

957

---

How do you start single user mode in clustered installations?

927

---

What is the default sql server instance name?

1009

---

What is the difference between a view and a stored procedure?

1016

---

When columns are added to existing tables, what do they initially contain?

1013

---

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

1062

---

What is the query and subquery?

1058

---

Explain what is dbcc?

994

---

What are the limitations/drawbacks or ssrs 2008 r2?

139

---

What is the difference between SQL notification and SQL invalidation?

1153

---

What are logical database components? : SQL Server Architecture

1013

---

Write a sql query to get zero records from a table having n number of records?

1164

---

What is difference between primary key and foreign key?

881

---