Answer Posted / sql2000

Lets start on what a view is, view is a name given to a
select statement. The select statement is executed when the
view name is called.

When you create index on the view the select statement is
materialized into a table and we have the contents of the
select statement as a table. This makes it faster at times
to run select statements on rather than the actual tables.
Hence it makes sense to create indexes on views.

Let me know if anyone has a better point of view on
this. :)

What are the different acid properties?

1013

---

Does windows server 2016 come with sql server?

876

---

How to create a testing table with test data in ms sql server?

1013

---

What are the disadvantages of indexes?

996

---

What is simple indexing method?

969

---

What is the difference between stored procedure and user defined functions?

1125

---

What are the 2 types of classifications of constraints in the sql server?

1042

---

what method you can use to reduce the overhead of Reporting Services data sources?

233

---

What are transactions and its controls?

1002

---

Explain how many normalization forms?

967

---

In which files does sql server actually store data?

850

---

How do I schedule a sql server profiler trace?

912

---

What is data block and how to define data block size?

974

---

Do you know what are the reporting services components?

917

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2159

---