Jeff Moden (9/15/2010)

---

[rant]

Of course, I also get ticked that object names in a FROM clause can't use a variable name. If I can do it using dynamic SQL, it...

Add in a SET @Topcount = 1 between the declare and...

I know *A* way, and it's not pretty. But to determine its validity before giving one of the gurus round here a chance come up with a better way,...

Need to use the second post's code, not the first, might be...

Code correction, need to cast the replicate or it trims itself as close to 8k as it can:

create table #tmp

(tID INT IDENTITY( 1,1),

TestString VARCHAR(MAX)

)

GO

INSERT INTO #tmp (TestString) VALUES (

REPLICATE( REPLICATE(...

GilaMonster (9/15/2010)

---

Craig Farrell (9/15/2010)

---

Can't argue that, but anytime I hear they filled the drive with their log, I usually assume the entire thing was active, and rolling back that monster...

GilaMonster (9/15/2010)

---

Craig Farrell (9/15/2010)

---

If you're stuck in recovery mode, it sounds like someone cycled the server. On a log THAT big, it can take a while. Around how...

Why was I afraid you'd say that? New thread created here. ...

Usually when this happens on an active database you force truncate the log immediately, and then proceed to an immediate full or differential backup, because you broke the log-chain.

If you're...

Hey Wayne, does substring still work if the data for the VARCHAR(MAX) is no longer stored in row, and goes out to a separate LOB page?

I thought I...

jcrawf02 (9/15/2010)

---

Thanks Craig, has to do with the actual report definition, not the datetime or anything. example WC1 vs WC2 vs WC3 to indicate which version of the 'Well Child'...

jcrawf02 (9/15/2010)

---

Build 50+ ForEachLoop containers with a dataFlow task in each, looking for the existence of a file with '*<reportID>*.txt' as a filetype, hard-coded columns in each dataflow that correspond...

WayneS (9/15/2010)

---

Craig Farrell (9/15/2010)

---

For the code, you'll...

It won't directly impact it, but it will let your logs get transferred faster because their smaller. You can find out more details about the specifics between full and...

:w00t: I never thought I'd get such delicious ideas for my... extracurricular activities... from a SQL forum. I like yer thinkin'.