Administration

  • Nice question Ravi. Learned something new today. Thanks!

  • Good one. Thanks 😎


    Sujeet Singh

  • Great question. I didn't research enough regarding clustered index and non-empty table, so I got it wrong this time. Learned something new.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • 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)

    +1

    I like it when you bring more to the table like that little tidbit.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Sorry, guys, I've been trying to resist, but finally had to say it.

    OMG, I *learned* something. That's horrible! I want my points back!

    😀

    (Brandie runs and hides now)

    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.

  • 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

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

  • Good question.

    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)

    I was tempted to just say "false" because if it were "true" everybody who hadn't a clue would have got it right, but we do have some questions where the "obvious" answer is actually the "correct" answer so I thought I should look it up to make sure; What I found confirmed that "false" was the right answer, and then when I came here I saw Paul's comment and discovered that I had still more reading to do.

    Thanks Ravi for the learning experience, and Paul for compounding it.

    I think you would get the same result ("false") if that flag (610) was on, provided all the new records fitted into existing pages, or the table was being replicated.

    Tom

  • 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)

    Yes Paul, there is a lot to understand about minimally logging in SQL Server. Setting the recovery model to Bulk-logged will not only make the transactions logged minimally.

    Thank you for providing us this link.

    Regards,
    Ravi.

  • Nice question.I got it correct.

    Malleswarareddy
    I.T.Analyst
    MCITP(70-451)

  • I choose right answer .... but what does it means 'minimal logging' ?

    just a bit tricky in my own opinion

    thanks

Viewing 10 posts - 16 through 25 (of 25 total)

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