G.R.Preethiviraj Kulasingham (8/9/2009)

---

For example, table & index partition is an EE only feature. I haven't tested this, but that is what BOL says 🙂

So I expect you...

I replied to it.

I think a few of the responses were...

I was going to post a detailed reply to the article, but I see that Gail beat me to it. (No fair! MAJOR time-zone head-start! 🙂 )

There's some...

GilaMonster (8/10/2009)

---

Woot. My muse has returned. Sat down over the weekend and hammered out 3 pages of an article that I've been staring blankly at for the last couple months....

You're welcome.

It's a single-pass version of that problem, and in tests I've done, it's MUCH faster.

That and deduping are the two best uses of Row_Number that I've found. I've used...

You're welcome.

Please don't double-post.

Try it this way:

UPDATE

[tblShipments]

SET

[tblShipments].[Bill To] = [T Bill To 2].[Bill To]

FROM

[tblShipments]

LEFT OUTER JOIN [T Bill To 2]

...

Please don't double-post in multiple forums on the same site.

Does this get you what you need?

;

WITH Statuses

AS (SELECT

...

Yeah, I could have challenged it more. Did that to someone who needed an ID with a "U" on the front of it, just the other day. Said...

When I added a PK, the scans went way down. When I added an index to each of the wages columns, on top of the PK (12 indexes +...

Aaron N. Cutshall (8/7/2009)

---

I couldn't agree more. One company I worked...

Matt Miller (8/7/2009)

---

Why not store the value as a number, and do...