Post reply

Are the posted questions getting worse?

  • October 16, 2011 at 8:55 am

    #1395068

    GilaMonster (10/16/2011)

    MysteryJimbo (10/16/2011)

    GilaMonster (10/16/2011)

    Oh, nice.... After pointing out that performance is not the main reason for partitioning.

    GilaMonster...Really I wonder from your comments ..!!!!!!

    Please read more about schema partitioning + SQL Alerts+ benefits of each one + Relevant Cases studies

    Should I quote from KT's partitioning whitepaper, KT's partitioning notes from immersion or a SQLPass presentation?

    I've missed that thread :-D. Will track it down.

    Look for posts from the self-proclaimed performance guru.

    Performace as pointed out by lowell. Made me chuckle.

  • October 16, 2011 at 9:43 am

    #1395072

    MysteryJimbo (10/16/2011)

    GilaMonster (10/16/2011)

    MysteryJimbo (10/16/2011)

    GilaMonster (10/16/2011)

    Oh, nice.... After pointing out that performance is not the main reason for partitioning.

    GilaMonster...Really I wonder from your comments ..!!!!!!

    Please read more about schema partitioning + SQL Alerts+ benefits of each one + Relevant Cases studies

    Should I quote from KT's partitioning whitepaper, KT's partitioning notes from immersion or a SQLPass presentation?

    I've missed that thread :-D. Will track it down.

    Look for posts from the self-proclaimed performance guru.

    Performace as pointed out by lowell. Made me chuckle.

    Let's not make a big deal out of it please. I can provide references if demanded but not right now (packing for flight home)

    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

  • October 16, 2011 at 1:23 pm

    #1395088

    GilaMonster (10/15/2011)

    Jeff Moden (10/15/2011)

    Heh... nah... you're a good friend... so I thawed the chops for ya. 😛

    And even de-boned and par-cooked em to be really nice.

    That was just for the 'if the query is 40% of the cost it will take 40% of the time of the batch' comment. One thing that I emphasised in all of my sessions this year is that query costs aren't times and aren't always right and that 40% of the cost of the batch does not mean 40% of the time of the batch

    That particular example had me squirming, as well, especially since I can give examples where the % of batch is 100% incorrect compared to the actual performance. IIRC, Grant even included such and example in one of his fine books.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • October 16, 2011 at 1:36 pm

    #1395090

    Jeff Moden (10/16/2011)

    GilaMonster (10/15/2011)

    Jeff Moden (10/15/2011)

    Heh... nah... you're a good friend... so I thawed the chops for ya. 😛

    And even de-boned and par-cooked em to be really nice.

    That was just for the 'if the query is 40% of the cost it will take 40% of the time of the batch' comment. One thing that I emphasised in all of my sessions this year is that query costs aren't times and aren't always right and that 40% of the cost of the batch does not mean 40% of the time of the batch

    That particular example had me squirming, as well, especially since I can give examples where the % of batch is 100% incorrect compared to the actual performance. IIRC, Grant even included such and example in one of his fine books.

    My entire spotlight session was devoted to cases where the cost is wrong and the effects it has, as was the last 20 min or so of my pre-con.

    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

  • October 16, 2011 at 5:46 pm

    #1395117

    GilaMonster (10/16/2011)

    MysteryJimbo (10/16/2011)

    GilaMonster (10/16/2011)

    MysteryJimbo (10/16/2011)

    GilaMonster (10/16/2011)

    Oh, nice.... After pointing out that performance is not the main reason for partitioning.

    GilaMonster...Really I wonder from your comments ..!!!!!!

    Please read more about schema partitioning + SQL Alerts+ benefits of each one + Relevant Cases studies

    Should I quote from KT's partitioning whitepaper, KT's partitioning notes from immersion or a SQLPass presentation?

    I've missed that thread :-D. Will track it down.

    Look for posts from the self-proclaimed performance guru.

    Performace as pointed out by lowell. Made me chuckle.

    Let's not make a big deal out of it please. I can provide references if demanded but not right now (packing for flight home)

    You're still there? Why don't you just move to Seattle? :w00t:

    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

  • October 16, 2011 at 5:51 pm

    #1395119

    GilaMonster (10/15/2011)

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

    Not enough of a detailed explanation according to Gail as she was trying to throw a shuriken, or rubber duck, or something at me.

    I was sitting with Jeff. What do you think I was throwing? 😉

    Maybe we should have arranged for all of the Threadizens at the Summit to be front row for Steve's presentation. I think he would have been pretty worried about heckling then! :-D:-D:-D

    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

  • October 16, 2011 at 6:02 pm

    #1395120

    Grant Fritchey (10/16/2011)

    BTW, I've just been deleting Thread emails for the last week. It was easier than trying to keep up. Did I miss anything big? Marriages, deaths, taxes, who won the Exceptional DBA of the Year award?

    Let's see:

    1. Marriage: yep, there was a SQLMarriage in Seattle last week.

    2. Death: (I hear yours is imminent if Gail hears you give out wrong info again.)

    3. Taxes: yep, yours went up (again). Oh... IRS wants to talk with you also...

    4. Some old hippee fellow that looks like Santa, but writes wicked fast T-SQL code.

    :-D:w00t::-P:-D

    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

  • October 16, 2011 at 8:08 pm

    #1395126

    WayneS (10/16/2011)

    Grant Fritchey (10/16/2011)

    BTW, I've just been deleting Thread emails for the last week. It was easier than trying to keep up. Did I miss anything big? Marriages, deaths, taxes, who won the Exceptional DBA of the Year award?

    Let's see:

    1. Marriage: yep, there was a SQLMarriage in Seattle last week.

    2. Death: (I hear yours is imminent if Gail hears you give out wrong info again.)

    3. Taxes: yep, yours went up (again). Oh... IRS wants to talk with you also...

    4. Some old hippee fellow that looks like Santa, but writes wicked fast T-SQL code.

    :-D:w00t::-P:-D

    Excellent summary.

    Oh, and Gail, in case you don't see this tweet from SirSQL:

    @GFritchey @SQLintheWild I used what I learned in your precon to fix an outage situation caused by a lazy spool. Instant ROI. Thanks!

    Whoop!

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • October 17, 2011 at 5:36 am

    #1395241

    Grant Fritchey (10/16/2011)

    BTW, I've just been deleting Thread emails for the last week. It was easier than trying to keep up. Did I miss anything big? Marriages, deaths, taxes, who won the Exceptional DBA of the Year award?

    Yeah... it seems some company is sending a DBA to space... 😉

    -Ki

  • October 17, 2011 at 6:32 am

    #1395269

    Kiara (10/17/2011)

    Grant Fritchey (10/16/2011)

    BTW, I've just been deleting Thread emails for the last week. It was easier than trying to keep up. Did I miss anything big? Marriages, deaths, taxes, who won the Exceptional DBA of the Year award?

    Yeah... it seems some company is sending a DBA to space... 😉

    I heard about that. It's probably a joke or there's some sort of wiggle room or something. I seriously doubt they would have already purchased a ticket from Space Adventures[/url] or anything like that.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • October 17, 2011 at 6:40 am

    #1395276

    Grant Fritchey (10/17/2011)

    Kiara (10/17/2011)

    Grant Fritchey (10/16/2011)

    BTW, I've just been deleting Thread emails for the last week. It was easier than trying to keep up. Did I miss anything big? Marriages, deaths, taxes, who won the Exceptional DBA of the Year award?

    Yeah... it seems some company is sending a DBA to space... 😉

    I heard about that. It's probably a joke or there's some sort of wiggle room or something. I seriously doubt they would have already purchased a ticket from Space Adventures[/url] or anything like that.

    It's certainly a joint venture of some sort. Knowing that RG will be doing a heck of a lot of advertising for SA (:-D). I'm sure they got a heck of a nice discount on the standard 110K $ for 15 minutes of fun :hehe:.

  • October 17, 2011 at 6:58 am

    #1395289

    Jeff Moden (10/16/2011)

    GilaMonster (10/15/2011)

    Jeff Moden (10/15/2011)

    Heh... nah... you're a good friend... so I thawed the chops for ya. 😛

    And even de-boned and par-cooked em to be really nice.

    That was just for the 'if the query is 40% of the cost it will take 40% of the time of the batch' comment. One thing that I emphasised in all of my sessions this year is that query costs aren't times and aren't always right and that 40% of the cost of the batch does not mean 40% of the time of the batch

    That particular example had me squirming, as well, especially since I can give examples where the % of batch is 100% incorrect compared to the actual performance. IIRC, Grant even included such and example in one of his fine books.

    I'd love to have a peek at this one. While playing with the delimitedsplit8k testbed, I found a rCTE solution which cost 2% of the batch when run with the T1 version. Whoopee! I thought, until I tested it in the framework and it came out 3.5 times slower. I've posted this up somewhere or other, but there's no harm in reminding folks that comparing queries this way simply doesn't work.

    Oh, and today I've had 333,000 actual rows and 125,000,000,000 estimated rows in the same operation...

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • October 17, 2011 at 7:13 am

    #1395298

    Back to work after the summit. It was a pleasure to meet everyone there. I had a blast. Once again Jeff, Johan and me did some sight seeing together on the last day of summit.

    -Roy

  • October 17, 2011 at 8:22 am

    #1395358

    Roy Ernest (10/17/2011)

    Back to work after the summit. It was a pleasure to meet everyone there. I had a blast. Once again Jeff, Johan and me did some sight seeing together on the last day of summit.

    Not to forget the 3 margueritas afterward 😀

    It has been a marvelous SQLpass once more.

    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

  • October 17, 2011 at 8:25 am

    #1395362

    Roy Ernest (10/17/2011)

    Back to work after the summit. It was a pleasure to meet everyone there. I had a blast. Once again Jeff, Johan and me did some sight seeing together on the last day of summit.

    So jealous!!! Not only did I really want to make it PASS but I lived in Seattle for several years and would love to get back there to visit old friends. Hard to believe it has been 15 years since I left there.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Viewing 15 posts - 30,916 through 30,930 (of 66,712 total)

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