Administration

  • Comments posted to this topic are about the item Administration

    Regards,
    Ravi.

  • Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Thank you Ravi-ji, Interesting one. 🙂

    (Though I selected the wrong answer, assuming that bulk import is on huge data and dropping indexes will improve the import process... and was considering bulk recovery model will do the minimal logging (some how)... :ermm: ... after reading the link provided there came to know that my analysis was completely illogical.)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Thanks!

    🙂

  • Its a tricky one, and worth knowing.

    There are so many rules about getting minimal logging.

  • nice reminder, thanks. Good to hear the table only has one clustered index! 🙂

    The points in the link about logging behaviour when you batch up bulk imports are important to note.

    ---------------------------------------------------------------------

  • This was removed by the editor as SPAM

  • Another thing I thought I learned and found out I didn't.

    Thanks, Ravi.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • The question didn't mention trace flag 610 (which would enable minimal-logging in this scenario) so I assumed it was off, and was rewarded with a green tick and a point.

    http://msdn.microsoft.com/en-us/library/dd425070.aspx (Summarizing Minimal Logging Conditions)

  • SQL Kiwi (9/11/2012)


    The question didn't mention trace flag 610 (which would enable minimal-logging in this scenario) so I assumed it was off, and was rewarded with a green tick and a point.

    http://msdn.microsoft.com/en-us/library/dd425070.aspx (Summarizing Minimal Logging Conditions)

    Thanks to Ravi for the question, and Paul for the amplification.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Thanks for the great question.



    Everything is awesome!

  • Thanks for the question. Took a little research to get the correct answer. Good one.

  • Thanks, Ravi..

    The question is interesting.. and Nice..

  • Great question Ravi, thanks!

    Interesting note about traceflag 610 SQL Kiwi, I was not familiar with that traceflag.

    Here is some more information on it:

    http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx

    EDIT - fixed a typo

  • sestell1 (9/11/2012)


    Great question Ravi, thanks!

    Interesting note about traceflag 610 SQL Kiwi, I was not familiar with that traceflag.

    Here is some more information on it:

    http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx

    EDIT - fixed a typo

    +1

Viewing 15 posts - 1 through 15 (of 25 total)

You must be logged in to reply to this topic. Login to reply