Morning Gail,

Great article and I hit the log with a DBCC SHrinkfile, which did the trick (had to start with a large target space value and reduce down.

Is there a...

Cheers Jeff!

Running it now. Do you know if this is a particularly resource - intensive Proc? I'm told IndexDefrag can bloat the log, and indeed it's gone...

Cheers Gail. A bit hung over still from last night. ...

GilaMonster (3/25/2012)

---

Now, about the corruption...

While I would still like to see the error messages to be sure, with a suspect log shipping secondary you're probably best off dropping the secondary...

Lynn Pettis (3/24/2012)

---

First, It isn't crappy software.

When you attempted to stop the job, exactly how did you do this? Please provide the exact steps or T-SQL code you used.

Second,...

GilaMonster (3/24/2012)

---

Jake Shelton (3/24/2012)

---

Hi all,

We have a DB whose 15-min interval log shipping recovery job has been failing for 2 weeks (wasn't me, I'm the whistle-blower, not the negligent!)...

GilaMonster (3/19/2012)

---

1) SQL code changes

2) Indexes

3) Application code changes

4) Database config changes

5) Hardware upgrades (IO predominately, very hard to max out a modern CPU with well-written code)

Restarting SQL is...

I'm still getting used to all those brackets... 😀

Thanks

Drew, thanks for the heads-up. As a man who appreciates clarity I am the last to complain when I'm fairly called out for being unclear.

Lynn Pettis (3/5/2012)

---

Somethin more like this?

Select

approxrank,

Count (approxrank) as BeltCount

From

PersonalFinance PF

Inner join PersonalProfiles PP

...

Hi Gail,

Indeed I do, and here are the first three columns of all 5 rows (the names have been changed to protect the guilty)

idnameusername

27Mick

29Mack

30Mock

31Muck

32Meckie

The ID values correspond exactly to...

You were right...

AssignedUsers_UserID

291243

271011

30688

31293

Still not sure why it's coming up with 6.84 million rows...

Also of interest is that I had to go back to the Control Flow tab to finish the flow of data out to csv, I think someone at Redmond has...

Koen Verbeeck (2/28/2012)

---

Yes, use the OLE DB Destination with the Fast Load option in favor of the SQL Server Destination.

What do you mean with "any good articles for 2K"?

Do you...

Koen Verbeeck (2/27/2012)

---

1) Yes. Although I wouldn't use the SQL Server Destination. The performance gain is neglible and it has certains downsides: it only works if the package runs on...