It will grow by the amount you set it (in mbs or %).

The best pratice is to figure out the amount of space that db will be needed 6-12 months...

HTH, come back anytime!

>>>>>

Or use Gail's fine article too. The tool just automates...

Tx. I guess it...

jd 60382 (8/9/2011)

---

South Central Pennsylvania now, used to live in the North Eastern Part of the state. I was only commenting on the current state of the economy at this...

Can you post the full sp? Maybe the biggest optimisation opportunity is to merge those statements.

This can script that data for you in 2 secs. Just found about it today and it's awesome!

http://www.ssmstoolspack.com/

I'd go with inserting the data in smaller batches and running tlog backups after x batches.

I never reall had troubles getting jobs in access and I was able to negociate decent rates (consulting). What part of the world are you in?

That's not what Gail is saying. She's saying that the function...

I'm sure it will. Maybe a small flash mob of people showing care is all he needs to turn...

No it's perfect.

In you SSRS report add a matrix.

The row group will be the campain.

The column group will be the Description

The data group will the the cost.

Roy Ernest (8/9/2011)

---

Really good Job. You handled him quite well. And...

You next port post could be worth 1 000 000 points.

Make it COUNT.

http://www.sqlservercentral.com/Forums/FindPost1156813.aspx

jcrawf02 (8/9/2011)

---

Pretty sure that's self-deprecation overdone, voiced out of frustration. Nice...