Post reply

Are the posted questions getting worse?

  • July 28, 2015 at 9:06 am

    #1815452

    GilaMonster (7/28/2015)

    A misspelling. Should have been klap (Afrikaans)

    Once again actually demonstrating the inaccuracy of your answers?

    😉

    Figured I would give you another reason to come to Summit - two people to thump.:-D

    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

  • July 28, 2015 at 9:19 am

    #1815457

    Careful, guys. Gail-baiting is a sure way to encourage the use of katanas.

    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.

  • July 28, 2015 at 9:28 am

    #1815460

    Brandie Tarvin (7/28/2015)

    Careful, guys. Gail-baiting is a sure way to encourage the use of katanas.

    Well, we'll just have to take her out to dinner then.

    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

  • July 28, 2015 at 9:30 am

    #1815461

    Brandie Tarvin (7/28/2015)

    Careful, guys. Gail-baiting is a sure way to encourage the use of katanas.

    Those are used for cutting steak right?

    Or are they the spindle-y things that they stack onion rings on?

    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

  • July 28, 2015 at 9:33 am

    #1815466

    SQLRNNR (7/28/2015)

    Brandie Tarvin (7/28/2015)

    Careful, guys. Gail-baiting is a sure way to encourage the use of katanas.

    Those are used for cutting steak right?

    Or are they the spindle-y things that they stack onion rings on?

    I'm beginning to think that Gail might be planning on using them to skewer us....:w00t::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

  • July 28, 2015 at 3:35 pm

    #1815567

    Okay, time for a Chicken Dentist 'cause I'm done trying to pull teeth on thread where someone thinks a loop is the only way to accomplish a one off report without even looking at possible alternatives.

  • July 28, 2015 at 3:43 pm

    #1815573

    Heh, I like the wording. OP is "set" on doing it with the loop. Puns are great 🙂

  • July 28, 2015 at 6:23 pm

    #1815597

    I love it when I learn something in an area where I thought I knew it all.

    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

  • July 29, 2015 at 1:13 am

    #1815634

    WayneS (7/28/2015)

    I love it when I learn something in an area where I thought I knew it all.

    You have made me very curious. What was the subject?

  • July 29, 2015 at 4:01 am

    #1815648

    WayneS (7/28/2015)

    I love it when I learn something in an area where I thought I knew it all.

    Well that explains why I lost all my SQL laarnin' yesterday.

    Stop stealing my brain! :w00t:

    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.

  • July 29, 2015 at 7:39 am

    #1815712

    BL0B_EATER (7/29/2015)

    WayneS (7/28/2015)

    I love it when I learn something in an area where I thought I knew it all.

    You have made me very curious. What was the subject?

    Table Variables. They automatically use a nolock query hint.

    (Please Thread, don't smite me for posting code here...)

    DECLARE @X TABLE (Col1 INT);

    SELECT Col1

    FROM @X

    OPTION (RECOMPILE, QUERYTRACEON 3604, QUERYTRACEON 8607);

    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

  • July 29, 2015 at 7:40 am

    #1815714

    Brandie Tarvin (7/29/2015)

    WayneS (7/28/2015)

    I love it when I learn something in an area where I thought I knew it all.

    Well that explains why I lost all my SQL laarnin' yesterday.

    Stop stealing my brain! :w00t:

    Now Brandie... I didn't learn this until after working hours. You had all day to get your #SQLLearning on! :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

  • July 29, 2015 at 7:48 am

    #1815718

    WayneS (7/29/2015)

    BL0B_EATER (7/29/2015)

    WayneS (7/28/2015)

    I love it when I learn something in an area where I thought I knew it all.

    You have made me very curious. What was the subject?

    Table Variables. They automatically use a nolock query hint.

    (Please Thread, don't smite me for posting code here...)

    DECLARE @X TABLE (Col1 INT);

    SELECT Col1

    FROM @X

    OPTION (RECOMPILE, QUERYTRACEON 3604, QUERYTRACEON 8607);

    SMITE

    SMITE

    SMITE

    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

  • July 29, 2015 at 7:51 am

    #1815722

    SQLRNNR (7/29/2015)

    WayneS (7/29/2015)

    BL0B_EATER (7/29/2015)

    WayneS (7/28/2015)

    I love it when I learn something in an area where I thought I knew it all.

    You have made me very curious. What was the subject?

    Table Variables. They automatically use a nolock query hint.

    (Please Thread, don't smite me for posting code here...)

    DECLARE @X TABLE (Col1 INT);

    SELECT Col1

    FROM @X

    OPTION (RECOMPILE, QUERYTRACEON 3604, QUERYTRACEON 8607);

    SMITE

    SMITE

    SMITE

    Ditto

    😎

  • July 29, 2015 at 7:55 am

    #1815725

    WayneS (7/29/2015)

    BL0B_EATER (7/29/2015)

    WayneS (7/28/2015)

    I love it when I learn something in an area where I thought I knew it all.

    You have made me very curious. What was the subject?

    Table Variables. They automatically use a nolock query hint.

    (Please Thread, don't smite me for posting code here...)

    DECLARE @X TABLE (Col1 INT);

    SELECT Col1

    FROM @X

    OPTION (RECOMPILE, QUERYTRACEON 3604, QUERYTRACEON 8607);

    Oh and TF 3604 is typically used for certain console commands to output to screen. In this case, it is used to send the output of TF 8607 to screen.

    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 - 49,696 through 49,710 (of 66,712 total)

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