Viewing 15 posts - 6,931 through 6,945 (of 9,725 total)
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
During the upgrade process, SQL Server 2k5 automatically creates a schema for every user. It's a "feature" that Microsoft put in for who knows what reason. Schemas are new to...
December 3, 2010 at 4:28 am
Henrico Bekker (12/3/2010)
Hi guys, could we get some comments on the today's QOTD please?Need some more senior input.
Yeah, but honestly, Microsoft could be more clear in their KB article too.
December 3, 2010 at 4:24 am
T-SQL is required to create the snapshot, but how many people create snapshots using jobs or SSIS packages? Most people open up SSMS to do it, ergo, the common perception...
December 3, 2010 at 4:22 am
Craig Farrell (12/2/2010)
How often do you re-write old code, except for a few specific core procs on any system?
Often enough that I save all my procs so I can re-use...
December 2, 2010 at 11:53 am
CirquedeSQLeil (12/1/2010)
Brandie Tarvin (12/1/2010)
Certifiable.Yeah. Couldn't resist that one. @=)
Yes I am - woohoo :hehe::satisfied::alien:
The proper response is "I know you are, but what am I?" :w00t:
December 2, 2010 at 10:48 am
artan_p (12/2/2010)
Hi!In my project I have used Qureis, maybe I must use procedures
Could it be my problem!?
We're not going to even try to answer that question until you tell us...
December 2, 2010 at 8:51 am
Can anyone point me to a good example of an abstract that was submitted for PASS? A weblink or something?
I want to apply as a speaker for SQL Rally and...
December 2, 2010 at 7:32 am
It sounds like either a network issue or a permissions issue. If you're not willing to look at Craig's questions and test them out for yourself to verify none of...
December 2, 2010 at 5:58 am
Viewing 15 posts - 6,931 through 6,945 (of 9,725 total)