GilaMonster (6/13/2012)

---

There's a difference between the pages being ~80% full because the fill factor is set to 80 and the pages being on average ~50% full because of page splits....

I'm not personally feeling all that able to help you on this one, but I've nudged a few of the other long time posters here and hopefully one of them...

This person has an urgent problem with a SQL 2k8R2 upgrade gone south on the master db. He's polite and feels it's very urgent, and is pretty thorough. ...

Awesome news and thanks for posting back with your solution, hopefully it'll help someone else one day.

I've seen that before, but usually only when you've got a linebreak of some...

That is... not how I learned the term Internal Fragmentation. My apologies for the confusion. Thank you for the clarifications.

The idea, however, that internal fragmentation on a page...

SueTons (6/12/2012)

---

Hi, I know that deleting a row can cause fragmentation since it creates free space within a page, also inserting can cause fragmentation due to page splits. A...

For the direct mechanics of the delete internally, this...

Search this site for an article by Jeff moden called 'Quirky Update'. Also other sources using "running totals" or "Cumulative Update" as your keywords. They'll help walk you...

Jeff Moden (5/19/2012)

---

P.S. Heh... that's gotta be your 6 talking because your mouth knows better. How do you...

Simply the first hit I found on my first google attempt:

http://blogs.msdn.com/b/mattm/archive/2008/03/03/connecting-to-mysql-from-ssis.aspx

There's a ton out there. Just google 'ODBC SSIS driver'. Pick your concerned software if you have one...

I'd say there's two sides to this particular coin. As an example, Indie Game Development can be a perfect place to admire the contrasts in the choices.

For example, there's...

Sure. This is a bit of psuedocode using 3 columns but it'll give you the gist:

INSERT INTO NewTable

(ColA, ColB, ColC)

SELECT

ot.ColA,

'Static1',

'Static2'

FROM

OldTable AS ot

Incorrect. If it's a functional Windows ODBC driver, it will function. Now, what you need to do to make it function will depend on the driver, it's personal...

n.heyen (6/12/2012)

---

I use the same OLE DB connection for the other 10 or so steps in he package and they all work. I've tried creating a new data flow and...

You're doing it right. If you're not getting any data in the viewer during the test run, then the original query isn't returning data to the process. Check...