Post reply

Throttle a Query in Mid-Execution

  • March 31, 2013 at 10:13 pm

    #73372

    Comments posted to this topic are about the item Throttle a Query in Mid-Execution

  • April 1, 2013 at 1:41 am

    #1602388

    Nice one, almost got me there :hehe:

    Cheers,

    JohnA

    MCM: SQL2008

  • April 1, 2013 at 5:21 am

    #1602417

    Nice new feature, too bad it does not work on 2008/R2 servers. But as we migrate more servers to 2012 I sure we'll use it more.

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

  • April 1, 2013 at 5:50 am

    #1602420

    Don't mind admitting I fell for this completely.

    Well done, Steve! :laugh:

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • April 1, 2013 at 6:04 am

    #1602422

    Ha ha ha...

    You got me... But here the time has past noon now 🙂

    Cheers,
    Prithiviraj Kulasingham

    Plan to Test your Plan!

  • April 1, 2013 at 6:10 am

    #1602423

    I was disappointed when the text of the editorial frankly admitted it being an April Fools prank. There goes the chance to read the comments of those who fell for it.

    This one is a lot better. I almost believed it, until I saw the syntax of the DBCC TRACEON command.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • April 1, 2013 at 6:52 am

    #1602437

    Loved it!

    Thanks for the morning smile Steve.

  • April 1, 2013 at 8:18 am

    #1602462

    LOL... :-P:-P

    Nice one...!!

  • April 1, 2013 at 9:08 am

    #1602486

    Wow, I was already formulating follow-up questions. You got me.

    Thomas

    Thomas LeBlanc, MVP Data Platform Consultant

  • April 1, 2013 at 9:12 am

    #1602488

    Glad you like it.

    I was curious how many might actually read the whole thing and not skip over my disclaimer sentence.

  • April 1, 2013 at 9:15 am

    #1602491

    Steve Jones - SSC Editor (4/1/2013)

    Glad you like it.

    I was curious how many might actually read the whole thing and not skip over my disclaimer sentence.

    Oops...

    Exposed. 🙁

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • April 1, 2013 at 9:15 am

    #1602492

    Hugo Kornelis (4/1/2013)

    I was disappointed when the text of the editorial frankly admitted it being an April Fools prank. There goes the chance to read the comments of those who fell for it.

    This one is a lot better. I almost believed it, until I saw the syntax of the DBCC TRACEON command.

    Yeah, I couldn't decide if I should reveal the joke or not. It's backfired both ways in the past, so I was hoping I might get some people that didn't read closely. Looking at the editorial comments, I think I got one.

  • April 1, 2013 at 9:37 am

    #1602504

    what if you enable trace flag 708, and use the (noaprilfool) hint

  • April 1, 2013 at 10:16 am

    #1602514

    jack-311987 (4/1/2013)

    what if you enable trace flag 708, and use the (noaprilfool) hint

    The universe implodes. Please don't try it.

    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

  • April 1, 2013 at 12:12 pm

    #1602556

    GilaMonster (4/1/2013)

    jack-311987 (4/1/2013)

    what if you enable trace flag 708, and use the (noaprilfool) hint

    The universe implodes. Please don't try it.

    Oh shoot, I hope I can go stop my run of that now!

    Does it take long before the universe starts imploding from running that?

Viewing 15 posts - 1 through 15 (of 26 total)

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