There may be any number of 'better' ways to accomplish this particular task, but the post was intended as a tutorial about how OVER() works, and an example of where...

I've used OVER() a few times when I copied something from a forum to solve a problem, and hacked it until it gave me the results I needed. I used...

Okay, here's what I ended up doing. I don't suppose it's 100% reliable, since the pattern -could- occur in a legit path, but it's unlikely enough in my case that...

Another thing that might help is to go back to the articles and add more keywords. I have occasionally had trouble finding something on this site because I didn't know...

You, and...

I don't know about for the net in general, but for this forum, maybe Steve could institute some sort of marking for people that know what they are talking about....

Still a relevant topic, even if the original question is old. Stuff like this resurfaces regularly, as new people enter the profession and run across older discussion threads in the...

Attitudes like "X" should always be "Y" are silly and counterproductive, usually wrong, and anyone spouting them should be sent to go stand in the corner for a while. Logs...

Jeff Moden (8/24/2016)

---

BTW... if the table isn't critical to a DR restore, you might want to simply move it to another database and add a synonym for it. That...

BLOB_EATER (8/24/2016)

---

For me partitioning is about manageability first and performance second.

Your MDF is 500MB with 8 years growth? I'm not so sure you need to go down this route......

The filtered indexes do seem to help. I didn't run any precise before-and-after metrics, but responses seem snappier. I also ran this command: UPDATE STATISTICS paleodata.tax.podrobnostitmp No idea if it...

Thanks for the extra tips, Jacob, I'll post results that way next time.

As for the statistics, I've no doubt you're right. The data in these columns is very 'clumpy' (is...