Answer / Jaspreet Kaur

"Filtered indexes" in SQL Server provide several benefits, including improved query performance, reduced storage space, and enhanced data compression. By creating an index only on a subset of data (based on specified filter conditions), SQL Server can quickly find the relevant rows for queries without having to scan the entire table. This leads to faster query execution times, particularly when dealing with large datasets.

What is a unique key constraint?

1 Answers  

---

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

---

What is the Control Flow in SSIS

1 Answers   HCL,

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

What is difference between delete & truncate commands?

1 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

Can primary key be null?

1 Answers  

---

Which virtual table does a trigger use?

3 Answers  

---

What is page in sql server?

1 Answers  

---

What happens to a trigger with multiple affected rows?

1 Answers  

---

What is the purpose of update statistics and scope_identity() function?

1 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---