Forum Replies Created
Viewing 4 posts - 226 through 229 (of 229 total)
-
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction
... declarative in his sense means specifying the result you want (chocolate chip cookies) rather than specifying a method of achieving it (make the mix, bake it). You've fallen...
-
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction
gserdijn (4/14/2009)
select square(count(1)) From master.sys.columns C1Oops! I had missed that one.
Nice !
-
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction
Tom.Thomson (4/29/2009)
gautamsheth2000 (4/13/2009)
Should use this code
Select count(*) From master.sys.columns C1 CROSS JOIN master.sys.columns C2
That's far too slow
Try instead:
select power(count(*),2) from master.sys.columns
Comparing equivalent code on SQL Server 2000...
-
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction
RBarryYoung (4/14/2009)
gautamsheth2000 (4/13/2009)
Should use this codeSelect count(*) From master.sys.columns C1 CROSS JOIN master.sys.columns C2
Yes indeed. Good job!
Using the offending solution took 14 seconds on a MacPro. When I ran...
Viewing 4 posts - 226 through 229 (of 229 total)