Answer / Arvind Kumar Tripathi

Filtered indexes in SQL Server 2008 offer several benefits, including improved query performance by reducing the number of rows that need to be scanned and processed, reduced storage usage due to smaller index sizes, and reduced fragmentation caused by frequent insertions and deletions.

Explain what are partitioned views and distributed partitioned views?

1 Answers  

---

How to provide values to user defined function parameters?

1 Answers  

---

What is SubQuery in SQL Server 2008

1 Answers   HCL,

---

What are number line correlation administrators will use while working with a subquery?

1 Answers  

---

What are the different types of collation sensitivity in sql server?

1 Answers  

---

What is the difference between a local and a global variable?

5 Answers  

---

What happens if strings are casted into wrong code pages in ms sql server?

1 Answers  

---

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

---

Where to find ntwdblib.dll version 2000.80.194.0?

1 Answers  

---

How to convert binary strings into integers in ms sql server?

1 Answers  

---

What is an example of a foreign key?

1 Answers  

---

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

---