Viewing 15 posts - 44,131 through 44,145 (of 59,063 total)
mtrafzer (4/16/2009)
April 16, 2009 at 10:12 am
Oh yeah... almost forgot... the "black art" running total method requires that you have the proper clustered index to work. It will not work correctly if you reference a...
April 16, 2009 at 1:32 am
Mr. Young... very nice job. Immensely entertaining article and follow up posts to boot. My hat is off to you, Sir... I know just what you're going through...
April 16, 2009 at 1:16 am
Michelle Gutzait (4/15/2009)
What are your thoughts about Adam Machanic's article:
http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/running-sums-redux.aspx ?
I tried to compare Adam's code to other options and came up with this...
April 16, 2009 at 12:52 am
Thomas (4/15/2009)
Look at features you need to know to write the while loop vs. the cross Join. In the case of the while loop, you need to know about the...
April 16, 2009 at 12:00 am
As always with such a hot topic, the great battle between the "intuitiveness" of cursors comes forward. The classic example on this thread seems to have been based on...
April 15, 2009 at 10:51 pm
James Tran (4/14/2009)
- Store the result data in table var with rownumber
- create a row index var...
April 15, 2009 at 9:44 pm
SanjayAttray (4/14/2009)
April 15, 2009 at 9:36 pm
Manie Verster (4/14/2009)
April 15, 2009 at 9:24 pm
ZA_Crafty (4/15/2009)
gautamsheth2000 (4/13/2009)
Should use this code 🙂Select count(*) From master.sys.columns C1 CROSS JOIN master.sys.columns C2
You can do even one better.
using the PK in count is faster than *
ie,
Select count(id)...
April 15, 2009 at 9:11 pm
Thomas (4/15/2009)
April 15, 2009 at 8:25 pm
Andy DBA (4/15/2009)
April 15, 2009 at 8:00 pm
Bob Hovious (4/15/2009)
Oh good. People keep using that word and I get paranoid.
Heh... isn't that an oxymoron in itself? 😛
I keep telling folks, you don't ever want...
April 15, 2009 at 4:35 pm
Bruce W Cassidy (4/15/2009)
I'm reading an article (it's work related, okay?) and I run across this paragraph:
"The first and most obvious reason is that the DW appliance...
April 15, 2009 at 4:33 pm
Lynn Pettis (4/15/2009)
Jeffrey Williams (4/15/2009)
April 15, 2009 at 4:30 pm
Viewing 15 posts - 44,131 through 44,145 (of 59,063 total)