Answer / Antul Awashthi

A Filtered Index is an index created on a subset of rows within a table, based on a filter predicate. It can significantly improve query performance for queries that frequently filter large tables and only require a small percentage of the total data.

Explain about local stored procedure?

1 Answers  

---

What is a user-defined function in the sql server and what is its advantage?

1 Answers  

---

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  

---

what is the cursor life span?

5 Answers   Evalueserve, HG,

---

What are the pros and cons of creating extended stored procedures?

1 Answers  

---

What is the filtered index?

1 Answers  

---

Explain syntax for viewing trigger?

1 Answers  

---

Can we write ddl in trigger?

1 Answers  

---

What are basics of policy management?

1 Answers  

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1 Answers  

---

List down some advantages of sql stored procedure?

1 Answers  

---

What is open database communication (odbc)?

1 Answers  

---