You posted this same question in another forum, and I replied there.

Please do not double-post.

You would add a WHERE clause.

Yes, I know that this reply is probably too vague for your purposes. But so is your questions. Give us more details, and we can...

DamianC (1/8/2016)

---

Hello

I have a table (policy) with approximately 1.5 million rows in it.

I have another table (userpolicy) with approximately 100k rows.

The first table has a column called policyid

The second table...

I didn't run your code, but if it gives you all dates and you need only those between two dates, then you probably can just add WHERE calDate BETWEEN @StartDate...

I agree with Jeff on asking the author.

However, I also wonder why you want to filter out duplicates at the CLR side. Isn't it more efficient to filter them in...

Thanks for the link, Jacob! That post confirms what I put out as speeculation.

Okay, did a small test and confirmed that my faith in Gail was justified (and my faith in my own understanding of index internals was not). After creating a test...

Thanks, Jeff! Found it, watched it, and Gail is pretty explicit about it.

Coming from a lot of people,...

Zohaib Anwar (1/8/2016)

---

Sean Lange (1/7/2016)

---

Zohaib Anwar (1/7/2016)

---

Hi,

I am trying to build attached query that is mentioned in the word document. I am struck on one point that is point number...

erics44 (1/8/2016)

---

Hugo Kornelis (1/8/2016)

---

Jeff Moden (1/7/2016)

---

Technically correct because only an rCTE can be an rCTE but the rather well...

er.mayankshukla (1/8/2016)

---

I need an explanation may be pointing to some whitepaper for the explanation of below:

In a unique non clustered index, the clustered key comes to leaf level only

in a...

Koen Verbeeck (1/8/2016)

---

rodjkidd (1/8/2016)

---

BWFC (1/8/2016)

---

Where did you see that? I can't find...

First: Are you moving from SQL Server 2012 (or older) to SQL Server 2014 (or newer)? In that case, the issues are most likely caused by the changed to cardinality...

There are unfortunately no answers to broad and generic questions like this.

As a rule of thumb, giving SQL Server more information is always better - not just for performance (your...

Jeff Moden (1/7/2016)

---

Technically correct because only an rCTE can be an rCTE but the rather well advertised rave in...