Forum Replies Created

Viewing 15 posts - 196 through 210 (of 371 total)

  • RE: Table space usage 1

    Wow, very elaborated question.

    It made my brain hurt for a second.

    I've got 3/4 options right.

    I only missed one which should have been basic knowledge to me:

    "The amount of space used...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 9, 2011 at 5:10 am

    #1405077

  • RE: What else have you done?

    jshahan (11/8/2011)

    Lastly, you reach a point in either case where the work just begins to make sense and you get that wonderful (and deeply needed) feeling of control.

    Well...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 8, 2011 at 2:43 pm

    #1404860

  • RE: FAST_FORWARD cursor blocking issue

    Ninja's_RGR'us (11/8/2011)

    Back to step 0.

    DELETE the cursor and rewrite to set based.

    Post the code if you need help doing that.

    😀 Of course, my friend. That will be arranged one day.

    The...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 8, 2011 at 7:50 am

    #1404559

  • RE: FAST_FORWARD cursor blocking issue

    GSquared (11/8/2011)

    You guys do realize that selecting into a table variable, and then running a cursor on the table variable, is pretty much what a Static cursor does all by...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 8, 2011 at 6:50 am

    #1404490

  • RE: Raw Materials - Recurses!

    Raw Materials always make me laugh hard in my office.

    Keep up the good work.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 8, 2011 at 3:45 am

    #1404351

  • RE: Intersect

    Koen Verbeeck (11/8/2011)

    It is always a good idea to run scripts from the internet on the master database of the production server 😀

    :laugh: :laugh:

    It crashes here are well and I'm...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 8, 2011 at 3:13 am

    #1404339

  • RE: Formating numbers

    If you can afford to wait 5 or 6 months, SQL Server 2012 is going to be released with what seems to be a great addition to the T-SQL commands:...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 7, 2011 at 1:50 pm

    #1404169

  • RE: Network Protocals

    Nice and easy question for a Monday morning.

    Thank you.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 7, 2011 at 3:08 am

    #1403823

  • RE: Never offend a captive audience

    I agree as well.

    In a romance we're dealing with fictional or real characters (and they can curse and do whatever they want) so we're able to take some literary freedom,...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 6, 2011 at 6:07 pm

    #1403759

  • RE: need help to improve my stored procedure

    Thank you for the link, Gail.

    It's a very well written article about a very important subject.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 5, 2011 at 12:34 pm

    #1403654

  • RE: File system task fails randomly

    huslayer (11/5/2011)

    wouldn't SSIS yell and gives an error for that?

    Probably yes.

    Have you tried to change the operation to "Copy File" instead of "Move File" and then have another File System...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 5, 2011 at 11:01 am

    #1403645

  • RE: FAST_FORWARD cursor blocking issue

    r.dragoi-1095738 (11/4/2011)

    I would select the rows first into a variable table and after that I would use the cursor (over the variable table)

    I would advise that as well.

    I may be...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 4, 2011 at 11:41 pm

    #1403582

  • RE: File system task fails randomly

    And another stupid question: maybe someone has the file opened or being used while your job is trying to delete it?

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 4, 2011 at 11:33 pm

    #1403578

  • RE: What else have you done?

    Evil Kraig F (11/4/2011)

    Good Lord. This is... going to sound a bit like a brag, but yeaaaahhhh...

    (these are the non-computer ones)

    - Janitor

    - Stock Broker

    - Costume Shop manager

    - Warehouse...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 4, 2011 at 5:13 pm

    #1403541

  • RE: SQL Replication

    AFAIK it's possible but you'll have to be careful with difference on features between Enterprise and Standard editions.

    More info here:

    http://blogs.msdn.com/b/repltalk/archive/2011/01/03/replication-features-in-various-editions-of-sql-server-2005-2008.aspx

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    November 4, 2011 at 4:46 pm

    #1403537

Viewing 15 posts - 196 through 210 (of 371 total)