indubitably :-D:-D

ALZDBA (8/19/2011)

---

WayneS (8/18/2011)

---

Steve Jones - SSC Editor (8/18/2011)

---

Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going....

Jeff Moden (8/18/2011)

---

I wonder if the new splitter from the "Tally OH!" article would have helped here. I've not done any heavy testing with it against VARCHAR(MAX) but some...

Nice

I'd expect the Dell raid controller to be better but the HP chipset and processor to be better or at least as good.

I am scratching my head on this one.

You...

Beyond doing a...

Along with that shrink, make sure you account for VLFs. Check the article in my sig list by Kimberly Tripp

innumerable

Yes, database first and then the masterkey.

Jeff Moden (8/18/2011)

---

Almost forgot to ask... how many "fields" did you have per "record" and what was the average length of each record in bytes for the delimited string method...

Jeff Moden (8/18/2011)

---

I've never used them. I've always used something else because they didn't use to be available. ...

For future reference, here is another query to help get to that head blocker

SELECT

[Session ID] = s.session_id,

[User Process] = CONVERT(CHAR(1),...

Change d:\blobstore to something like d:\blobstore2

Revenant (8/18/2011)

---

crookj (8/18/2011)

---

Ray K (8/18/2011)

---

crookj (8/18/2011)

---

Ray K (8/18/2011)

---

VCR!!!

(I'm old fashioned -- what...

There are many reasons a master key may be required (TDE, create encrypted data in a column, filestream). In all of these cases, you should backup the master key....