Without seeing your DDL, I can't be sure, but it sounds like your non-clustered index doesn't use tran1 in the first column.

I heard a lecture at a SQL Saturday that...

Ninja's_RGR'us (7/20/2011)

---

Brandie Tarvin (7/20/2011)

---

On a semi-technical note, can I just say that I figured out how to do a JOIN to an UNPIVOT without using a derived table in the...

Can you update it to VARCHAR(MAX) without breaking...

Why would a combination of REPLACE(), LIKE() and PATINDEX() not work here?

EDIT: Like in Lowell's example? It's set based, no looping. Looping bad if you don't need to do it.

Thanks, Gail. I appreciate you verifying that for me.

So just restore over the exist rather than delete first?

My advice would be to use Dynamic SQL. Declare a variable, set the variable's value to the sql command above (with the date / time info concated into the string),...

Have you tried the REPLACE() function?

On a semi-technical note, can I just say that I figured out how to do a JOIN to an UNPIVOT without using a derived table in the mix?

I'm so proud...

Speaking of DVDs, who gets the proceeds of the Summit DVDs? Do the presenters get any cut of that at all?

Ninja's_RGR'us (7/20/2011)

---

Jeff Moden (7/20/2011)

---

David Burrows (7/20/2011)

---

Used to correspond with Frank a lot but I think he changed jobs and email. He does post on another forum.

Thanks for being one of...

My vote is in. I hope you get it, Jeff. You're the only one of the lot that I know actually has a couple of "official" SQL phrases coined.

On a...

Revenant (7/18/2011)

---

bopeavy (7/18/2011)

---

...

Craig Farrell (7/17/2011)

---

Brandie, my apologies, I didn't mean to completely skip this, and somehow I did....

Gail and I are both recommending that you avoid shrinking the data file if at all possible. The database claimed that space because it uses it, even if only occasionally....