Viewing 15 posts - 6,901 through 6,915 (of 9,707 total)
sqldba_icon (12/3/2010)
Brandie the column i have deleted is a ntext data type.Would DBCC Cleantable still help? If not how do i clear space , please advice.
Do you have a...
December 3, 2010 at 8:29 am
Patrick2525 (12/3/2010)
December 3, 2010 at 8:08 am
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...
December 3, 2010 at 7:12 am
Chris Morris-439714 (12/3/2010)
What folks often forget about tally tables is that they are a source of rows as well as numbers.
I've actually used a Tally Table to do that too,...
December 3, 2010 at 6:43 am
stewartc-708166 (12/3/2010)
There is a difference between the data providers to connect to Excel pre 2007 vs post 2007.
Ah. Good to know. Thanks for clarifying.
December 3, 2010 at 5:34 am
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...
December 3, 2010 at 5:31 am
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...
December 3, 2010 at 5:27 am
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...
December 3, 2010 at 5:24 am
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...
December 3, 2010 at 5:21 am
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...
December 3, 2010 at 5:19 am
stewartc-708166 (12/2/2010)
What version of excel source & destination?
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...
December 3, 2010 at 5:11 am
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....
December 3, 2010 at 5:11 am
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...
December 3, 2010 at 5:06 am
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...
December 3, 2010 at 4:52 am
sqldba_icon (12/2/2010)
John Mitchell-245523 (12/2/2010)
It could be that deleting the column freed a certain amount of space on each data page, but...
December 3, 2010 at 4:42 am
Viewing 15 posts - 6,901 through 6,915 (of 9,707 total)