Post reply

Are the posted questions getting worse?

  • September 15, 2011 at 1:47 pm

    #1382241

    ALZDBA (9/15/2011)

    SQLRNNR (9/15/2011)

    WayneS (9/15/2011)

    SQLRNNR (9/15/2011)

    Just saying that we only need 98 more posts for 30,000

    how many?

    Ummm - 96

    Make up your mind. No guessing 😉

    Bah! This is a SQL Server board!

    How many are left? "It Depends!"

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • September 15, 2011 at 3:29 pm

    #1382290

    Please let's not have quotes of every post that counts down from 95, 94, 93.

    I'm going out of town for a few days. I'm hoping that I don't have 300 posts in this thread when I get back :w00t:

  • September 15, 2011 at 4:15 pm

    #1382298

    Steve Jones - SSC Editor (9/15/2011)

    Please let's not have quotes of every post that counts down from 95, 94, 93.

    I'm going out of town for a few days. I'm hoping that I don't have 300 posts in this thread when I get back :w00t:

    Shouldn't have given us any ideas!!!

    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 15, 2011 at 4:18 pm

    #1382299

    SQLRNNR (9/15/2011)

    Steve Jones - SSC Editor (9/15/2011)

    Please let's not have quotes of every post that counts down from 95, 94, 93.

    I'm going out of town for a few days. I'm hoping that I don't have 300 posts in this thread when I get back :w00t:

    Shouldn't have given us any ideas!!!

    Ya you're just asking for it 😛

  • September 15, 2011 at 4:23 pm

    #1382300

    Ninja's_RGR'us (9/15/2011)

    SQLRNNR (9/15/2011)

    Steve Jones - SSC Editor (9/15/2011)

    Please let's not have quotes of every post that counts down from 95, 94, 93.

    I'm going out of town for a few days. I'm hoping that I don't have 300 posts in this thread when I get back :w00t:

    Shouldn't have given us any ideas!!!

    Ya you're just asking for it 😛

    Yeah, saying that is kinda like this:

    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 15, 2011 at 6:55 pm

    #1382343

    Steve Jones - SSC Editor (9/15/2011)

    Please let's not have quotes of every post that counts down from 95, 94, 93.

    I'm going out of town for a few days. I'm hoping that I don't have 300 posts in this thread when I get back :w00t:

    You mean you want us to find new ways of fixing it? Surely you want us all be too honest to find something other than the tried a tested cheat? So if we do it without quoting 95 and on downwards you'll be disappointed in us?

    Tom

  • September 15, 2011 at 9:26 pm

    #1382366

    Tom.Thomson (9/15/2011)

    Steve Jones - SSC Editor (9/15/2011)

    Please let's not have quotes of every post that counts down from 95, 94, 93.

    I'm going out of town for a few days. I'm hoping that I don't have 300 posts in this thread when I get back :w00t:

    You mean you want us to find new ways of fixing it? Surely you want us all be too honest to find something other than the tried a tested cheat? So if we do it without quoting 95 and on downwards you'll be disappointed in us?

    Let's just do this instead

    DECLARE @CountDownFrom Int

    SELECT @CountDownFrom = 83

    Begin

    WITH Nbrs_2( n ) AS (SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 0),

    Nbrs_3( n ) AS ( SELECT 1 FROM Nbrs_2 n1 CROSS JOIN Nbrs_2 n2 CROSS JOIN Nbrs_2 n3)

    , tally (n) as (SELECT ROW_NUMBER() OVER (ORDER BY n)

    FROM Nbrs_3

    )

    Select N

    From tally

    Where N <= @CountDownFrom

    Order By N Desc

    End

    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 15, 2011 at 11:55 pm

    #1382389

    SQLRNNR (9/15/2011)

    Tom.Thomson (9/15/2011)

    Steve Jones - SSC Editor (9/15/2011)

    Please let's not have quotes of every post that counts down from 95, 94, 93.

    I'm going out of town for a few days. I'm hoping that I don't have 300 posts in this thread when I get back :w00t:

    You mean you want us to find new ways of fixing it? Surely you want us all be too honest to find something other than the tried a tested cheat? So if we do it without quoting 95 and on downwards you'll be disappointed in us?

    Let's just do this instead

    DECLARE @CountDownFrom Int

    SELECT @CountDownFrom = 83

    Begin

    WITH Nbrs_2( n ) AS (SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 1 UNION all

    SELECT 0),

    Nbrs_3( n ) AS ( SELECT 1 FROM Nbrs_2 n1 CROSS JOIN Nbrs_2 n2 CROSS JOIN Nbrs_2 n3)

    , tally (n) as (SELECT ROW_NUMBER() OVER (ORDER BY n)

    FROM Nbrs_3

    )

    Select N

    From tally

    Where N <= @CountDownFrom

    Order By N Desc

    End

    OK, NOW you're in deep troubles:angry: ..... Code in The Thread :sick:.... blasphemy!!! :laugh::hehe:

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • September 16, 2011 at 6:50 am

    #1382513

    By the time this discussion is over, we'll have reached 30,000! 😀

    +--------------------------------------------------------------------------------------+
    Check out my blog at https://pianorayk.wordpress.com/

  • September 16, 2011 at 6:56 am

    #1382521

    As proven more than once, we take it further than the end in The Thread :hehe::Wow:

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • September 16, 2011 at 7:09 am

    #1382526

    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?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 16, 2011 at 7:31 am

    #1382534

    GilaMonster (9/16/2011)

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

    Spot on ! Sorry for that ...

    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 love that article because it covers most needed basics. So I referenced it in many fora.

    Maybe it only needs the shrinking Don't and Do ( notice the order 😉 )

    and off course the impact of all snapshot stuff they added. (Is there / Does it ?)

    Maybe all it needs is a forwarding pointer :w00t: to an advanced article covering e.g. VLF-management, how to investigate the log and stuff that can help out doing just that.

    I hope this gets your keyboard being trashed 😀

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • September 16, 2011 at 7:44 am

    #1382547

    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?

    Might not be a bad idea to go a little more into how replication, mirroring, log-shipping, and CDC affect the log.

    A mention of a tail-log backup/restore might be good as I think most people don't know/understand that.

    Of course both of those things could go into an advanced article as already mentioned.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • September 16, 2011 at 7:52 am

    #1382551

    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?

    This may belong in a more advanced article, but discussing the effects of log growth on the disk subsystem could be of use. How much do you allow for autogrowth of said log? What could be the impact of the log growing out of control (disk full database down)? Also, knowing that growths can cause disk fragmentation and will have a negative impact on performance.

    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 7:58 am

    #1382555

    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?

    Configuration? Things like people adding extra log files because they don't understand that it doesn't actually improve performance?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 15 posts - 29,911 through 29,925 (of 66,712 total)

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