I was using window functions, and this appeared to work, but it's a small sample size, so perhaps there's a flaw here:

SELECT t.*

FROM ( SELECT top 10

...

IMHO (11/24/2015)

---

I think they call...

swwg69 (11/24/2015)

---

Corporations allow the owners to have limited liability. That also makes the guys making the BIG money more casual about these problems. If someone took 100 million...

don't drop your framework or view on table design.

If I'm staging data here, pulling from unclean sources, do I need a PK or non-nullable columns? It's a perfectly valid design,...

What's previous?

The order of rows has no meaning in SQL Server. The way you insert them doesn't matter.

Right now your second row has a larger id and a later last...

I'm not sure it's that hard to go from 2005 sp4+ to 2016. The core features are there and not much has been removed, though lots deprecated. I suppose if...

Ed Wagner (11/23/2015)

---

Steve Jones - SSC Editor (11/23/2015)

---

So, the filter is learning, though it misses some I...

Andy Warren (11/23/2015)

---

Spelled subscription wrong:-)

Its interesting to see MS moving to the subscription model and doing so at reasonable prices. For most employees Im not sure it matters - they...

I'm not sure that's true. The cost of the licensing might go up, or might not. MS has maintained prices for two versions at times. In that case, maybe it's...

So, the filter is learning, though it misses some I don't understand.

However the filter scans post-post. This...

JustMarie (11/23/2015)

---

In upper management speak 'technical debt' has no value add. The code works so what's the point in spending time aka money on it?

The real trick is to...

liebesiech (11/23/2015)

---

Technical dept, if not handled soon, will cause issues and unwanted compromises down the road.

...until I was looking for a feature to be completed and the technical debt...

chrisn-585491 (11/23/2015)

---

We are dancing around the one of biggest expenses in the IT budget: licensing, SQL Server licensing in most of our cases.

For the cost of SS 2014 or SS...

We don't want a captcha as people are mostly registered when they post. It's an annoyance for many, and perhaps might not prevent replies from spammers.

I suspect there's a hole...

In what way? Is it because you do better being led...