Do you have a...

Patrick2525 (12/3/2010)

---

Within SSMS, click on Replication -> Publications, right click -> New Publication, and follow the wizard for either a Merge or Snapshot replication, and a snapshot will be created!...

Articles like this always interest me. .

http://education.yahoo.net/articles/quick_career_changes.htm?kid=1BOPU

Forget about the paralegal reference. Look at the others. How many of you have ever been in a situation where salaries like this would...

I've actually used a Tally Table to do that too,...

Ah. Good to know. Thanks for clarifying.

Josh,

Can you give us DDL code for the other tables too? And it would help to know which of those tables in the query is the one that #mytable is...

If it does need to happen in SSIS, delete via the Execute SQL Task in Control Flow. Don't use the OLE DB SQL Component in the data flow task. As...

I'm sort of new myself, having taken classes a good while ago, but not having had a chance to implement the information learned from them. So what I'm giving you...

If you can open up the SSIS packages in BIDS (doubtful if they've lost their project connections), then you can see the path in the Properties window by highlighting the...

If you're upgrading to 2005, not 2008, I recommend using your Procs as the Source in SSIS. There's better performance and less overhead than doing a table to table pull.

What...

Version shouldn't matter to SSIS. Especially if SQL's been properly updated with service packs and what not. I believe MS has been updating...

If you don't know SSIS, the learning curve can be pretty rough. But there are a few things to remember:

Data Flow Task

Excel Source

Excel Destination

Those are the three objects you'll need....

Something not mentioned here, but happens in my work environment. Backup files take up space too.

If you're not clearing out your backup files on a regular basis, and they...

I usually only need the double quotes from SQL Server when my path name has a space in it. You might try it without the double quotes and see what...

sqldba_icon (12/2/2010)

---

John Mitchell-245523 (12/2/2010)

---

How do you know that the individual column used 100GB?

It could be that deleting the column freed a certain amount of space on each data page, but...