Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Throttle a Query in Mid-Execution Expand / Collapse
Author
Message
Posted Monday, April 1, 2013 9:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 5,977, Visits: 8,237
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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1437486
Posted Monday, April 1, 2013 9:15 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:56 PM
Points: 33,202, Visits: 15,348
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1437488
Posted Monday, April 1, 2013 9:37 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:48 AM
Points: 55, Visits: 143
what if you enable trace flag 708, and use the (noaprilfool) hint
Post #1437503
Posted Monday, April 1, 2013 10:16 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 7:53 AM
Points: 42,822, Visits: 35,952
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 2008, MVP
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

Post #1437514
Posted Monday, April 1, 2013 12:12 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:19 AM
Points: 980, Visits: 5,112
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?
Post #1437559
Posted Monday, April 1, 2013 12:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 9, 2014 11:56 AM
Points: 3, Visits: 88
You got me. That was fun!
Post #1437573
Posted Monday, April 1, 2013 1:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 17, 2013 7:14 PM
Points: 7, Visits: 30
Darn shame that this feature came out on April 1st.

We did not get what we wanted in the Resource Governor, so we had to implement our own tools to kill a query once it has run more than x amount of time or has an open transaction for more than y amount of time. This works all 365 days of the year!

I wish SQL Server had a SQL Judge, Jury and Cop rolled-into-one feature which would summarily execute a query once it has used up more than a set of defined resources. Very, very useful and needed for a live application that needs to be UP all the time without DBAs having to get paged.



Post #1437583
Posted Monday, April 1, 2013 2:32 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:53 PM
Points: 543, Visits: 1,655
anil.nair@gtnexus.com (4/1/2013)

I wish SQL Server had a SQL Judge, Jury and Cop rolled-into-one feature which would summarily execute a user once it has used up more than a set of defined resources


Fixed it for you.
Post #1437611
Posted Tuesday, April 2, 2013 5:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, August 22, 2014 5:10 PM
Points: 228, Visits: 801
I was patting myself on the back for not having fallen for any jokes on April Fools day this year...then I read your article a day after it was written
Post #1437829
Posted Tuesday, April 2, 2013 5:33 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 3:38 AM
Points: 986, Visits: 795
One for the wibni list
Post #1437831
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse