I've always preffered to stay away from maint. plans. They've been too buggy, unreliable and hard if not impossible to adjust to very specific needs.

Yes you need 520 GB.

The restore makes a perfect copy of the backed up DB. File sizes included

Lasse Johansen (5/3/2011)

---

Would moving the trans not create an integrety problem in that someone could update the AccountType in between the checking and inserting?

I tried to circumvent this by...

How can you NOT use SSMS?

Do you mean SSMS import wizard?

SQLRNNR (5/3/2011)

---

Haha - my phone probably streams faster than...

Actually now that I think of it I <almost>...

openrowset

Who do you think I was probing with the...

Either put a date in there or sort by year, then month.

The date is more work but it should be less work for the server to sort.

Ya, I've never had a video that was so big that I couldn't stream it. So I'm not too worried :hehe:.

GilaMonster (5/3/2011)

---

Ninja's_RGR'us (5/3/2011)

---

Steve Jones - SSC Editor (5/3/2011)

---

There are a few things that will automatically go to disk with tempdb. After some checking, you cannot get away from spillage during...

14 day trial

http://www.red-gate.com/products/sql-development/sql-compare/download

Steve Jones - SSC Editor (5/3/2011)

---

There are a few things that will automatically go to disk with tempdb. After some checking, you cannot get away from spillage during queries. If...

You wanna...

Just run the SQL Server install process and Pick SSRS in the options to install. You might as well include SSAS / SSIS while you're at it.

At some point...