Pointless challenge for 2009

So you've gone back to work and can't really get back into it after all that chocolate and booze. Here's a little challenge.

Phil Brammer wondered what would happen to the usecounts column in the sys.dm_exec_cached_plans dmv when you hit the limit of an integer.

The problem is that the limit of an integer is 2147483647.

So the challenge is to write code that will result in the limit being hit as quickly as possible.

Also take into consideration use of multi core machines.

With the code I tried I was shocked at the rate of executions that can be achieved, on sqlexpress on a 8 core machine (note express is limited to 4 cores) I got 1/2 million requests/second.

---

-

Source Click Here.