Post reply

Are the posted questions getting worse?

  • September 16, 2011 at 7:59 am

    #1382556

    GilaMonster (9/16/2011)

    I suspect this got lost in all the 'helping Grant abuse SQL' posts...

    Another request:

    I'm bunking tonight and starting the rewrite of my rather old (and second-ever) article Managing Transaction Logs[/url]. Other than when and when not to shrink (which definitely has to go in there), what else do people think I need to add or expand on?

    I'm adding a whole section on why not to shrink, when shrinking is fine and how to. I'm cutting the recovery model stuff down (as there's another article I can reference) and adding a mismanagement section. Anything else that needs covering?

    How about limiting your db to one tlog file?

    -Dan

  • September 16, 2011 at 8:02 am

    #1382559

    Well, crap... Sorry GSquared - there must be an echo in here. 😀

  • September 16, 2011 at 8:17 am

    #1382570

    Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight, but I'm not completely happy with it - I'd like to find something else before there are too many blogs out there to redo with a different tool.

    Thanks!

    (Edit: 72 to go to 30000!)

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • September 16, 2011 at 8:26 am

    #1382573

    How about an intro to VLFs? VLFs is not something every one knows about. Also how logs are written and read from it?

    -Roy

  • September 16, 2011 at 8:28 am

    #1382575

    WayneS (9/16/2011)

    Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight, but I'm not completely happy with it - I'd like to find something else before there are too many blogs out there to redo with a different tool.

    Thanks!

    (Edit: 72 to go to 30000!)

    I'm hosted on wordpress.com and there you can only have [sourcecode language="sql"] + various switches.

    It's not bad, what exactly doesn't fit your needs?

    -- Gianluca Sartori

  • September 16, 2011 at 8:35 am

    #1382582

    I'm installing an instance for a new third party software and I would really appreciate your advice on the instance name.

    In this shop each instance name must start with a 7 char string (determined by a rather complicated algorithm - SQLITBI in this case) and then you have 3 chars that should identify what the instance does.

    Since the application name is "Waterfall", could SQLITBIWTF suit? 😀

    -- Gianluca Sartori

  • September 16, 2011 at 8:55 am

    #1382591

    Gianluca Sartori (9/16/2011)

    I'm installing an instance for a new third party software and I would really appreciate your advice on the instance name.

    In this shop each instance name must start with a 7 char string (determined by a rather complicated algorithm - SQLITBI in this case) and then you have 3 chars that should identify what the instance does.

    Since the application name is "Waterfall", could SQLITBIWTF suit? 😀

    Looks good to me. The shortened name clearly identifies which application is being serviced.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • September 16, 2011 at 9:02 am

    #1382598

    GilaMonster (9/16/2011)

    I suspect this got lost in all the 'helping Grant abuse SQL' posts...

    Another request:

    I'm bunking tonight and starting the rewrite of my rather old (and second-ever) article Managing Transaction Logs[/url]. Other than when and when not to shrink (which definitely has to go in there), what else do people think I need to add or expand on?

    I'm adding a whole section on why not to shrink, when shrinking is fine and how to. I'm cutting the recovery model stuff down (as there's another article I can reference) and adding a mismanagement section. Anything else that needs covering?

    I saw it, just nothing to suggest.

  • September 16, 2011 at 9:06 am

    #1382600

    Roy Ernest (9/16/2011)

    How about an intro to VLFs? VLFs is not something every one knows about. Also how logs are written and read from it?

    I think the topic on VLFs could be an entire article by itself. Introducing the concept (but IIRC she did that in another article) at a low level could work.

    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

  • September 16, 2011 at 9:08 am

    #1382601

    WayneS (9/16/2011)

    Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight, but I'm not completely happy with it - I'd like to find something else before there are too many blogs out there to redo with a different tool.

    Thanks!

    (Edit: 72 to go to 30000!)

    I think you will find that problem with most syntax tools. I am not particularly fond of any of them but wp-synhighlight works the best for me of what I have tested. At this point, I am in no mood to go back and change - too many posts.

    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

  • September 16, 2011 at 9:08 am

    #1382602

    WayneS (9/16/2011)

    Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight, but I'm not completely happy with it - I'd like to find something else before there are too many blogs out there to redo with a different tool.

    I'm getting ready to move my website / blog to WP and would also like the answer to this. What tool should I use for the T-SQL Code?

    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.

  • September 16, 2011 at 9:10 am

    #1382605

    Gianluca Sartori (9/16/2011)

    WayneS (9/16/2011)

    Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight, but I'm not completely happy with it - I'd like to find something else before there are too many blogs out there to redo with a different tool.

    Thanks!

    (Edit: 72 to go to 30000!)

    I'm hosted on wordpress.com and there you can only have [sourcecode language="sql"] + various switches.

    It's not bad, what exactly doesn't fit your needs?

    Will that work if I'm hosting on my own domain instead of wordpress.com?

    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.

  • September 16, 2011 at 9:12 am

    #1382608

    Brandie Tarvin (9/16/2011)

    Gianluca Sartori (9/16/2011)

    WayneS (9/16/2011)

    Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight, but I'm not completely happy with it - I'd like to find something else before there are too many blogs out there to redo with a different tool.

    Thanks!

    (Edit: 72 to go to 30000!)

    I'm hosted on wordpress.com and there you can only have [sourcecode language="sql"] + various switches.

    It's not bad, what exactly doesn't fit your needs?

    Will that work if I'm hosting on my own domain instead of wordpress.com?

    Sorry, I have no idea.

    -- Gianluca Sartori

  • September 16, 2011 at 9:17 am

    #1382613

    calvo (9/16/2011)

    Gianluca Sartori (9/16/2011)

    I'm installing an instance for a new third party software and I would really appreciate your advice on the instance name.

    In this shop each instance name must start with a 7 char string (determined by a rather complicated algorithm - SQLITBI in this case) and then you have 3 chars that should identify what the instance does.

    Since the application name is "Waterfall", could SQLITBIWTF suit? 😀

    Looks good to me. The shortened name clearly identifies which application is being serviced.

    ... and in case you forget it, you still have something to say!

    -- Gianluca Sartori

  • September 16, 2011 at 9:22 am

    #1382617

    Gianluca Sartori (9/16/2011)

    calvo (9/16/2011)

    Gianluca Sartori (9/16/2011)

    I'm installing an instance for a new third party software and I would really appreciate your advice on the instance name.

    In this shop each instance name must start with a 7 char string (determined by a rather complicated algorithm - SQLITBI in this case) and then you have 3 chars that should identify what the instance does.

    Since the application name is "Waterfall", could SQLITBIWTF suit? 😀

    Looks good to me. The shortened name clearly identifies which application is being serviced.

    ... and in case you forget it, you still have something to say!

    Swap the BI and IT to get SQL BE IT

    SQLBIITWTF

    Then you can add several neat acronyms in lieu of WTF

    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

Viewing 15 posts - 29,926 through 29,940 (of 66,000 total)

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