Viewing 15 posts - 781 through 795 (of 2,268 total)
you could use SSIS , though you wont need the insert code
October 12, 2010 at 7:12 am
Deepthy (10/12/2010)
Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Fuzzy...
October 12, 2010 at 5:51 am
atul-957304 (10/11/2010)
Rebuild all indexes or run update statistics agains't the database. Microsoft has said following the sql2008 r2 upgrade you must rebuild database indexes and/or statisticsThanks
Do you have a...
October 11, 2010 at 10:10 am
are you saying that the amount of data is causing the full backup to take too long ? or is the problem that the databse is performing badly?
becasue at...
October 11, 2010 at 9:08 am
Or if you want a pure SSIS solution you could opt for 3 sperate lookups
one for each for home, business, mobile
and then add each of these as a seperate...
October 11, 2010 at 7:09 am
I am not sure if there is a function that will deal correctly with business days as opposed to a calendar day. In this situation have you considered building...
October 11, 2010 at 7:00 am
No to solve the problem you need to schedule regular t-log backups.
October 11, 2010 at 6:28 am
shanila_minnu (10/11/2010)
Thanks for the reply.will be there any performance impact while running sql profiler?Will trc file occupy more space.
Don't bother running a SQL profiler trace, it won't help you...
October 11, 2010 at 6:19 am
Normally in a phone interview they are interested in hearing about your experience and details of projects that you have worked on. In my experience they save the in-depth...
October 8, 2010 at 9:11 am
Have to tried installing the tools by themselves, without running setup.exe ?
I think the file to run is called SQLTools.exe
October 8, 2010 at 6:33 am
Pradyothana Shastry (10/8/2010)
Check the indexes and as well as fragmentation level too
would an upgrade change the fragmentation level?
October 8, 2010 at 4:27 am
Cost is big factor , especially due to huge gap in price.
However a lot of people also pick SSIS because it has a lot better documentation and since it uses...
October 8, 2010 at 2:43 am
Are you performing t-log backups on these databases?
October 8, 2010 at 2:34 am
Viewing 15 posts - 781 through 795 (of 2,268 total)