Viewing 15 posts - 1,066 through 1,080 (of 5,590 total)
Kenneth Wymore (8/25/2011)
Wayne - Any chance those edited sections will appear in a future article?
Always a chance, and it would give me an opportunity to expand upon it also.
August 25, 2011 at 3:40 pm
Jeff Moden (8/25/2011)
August 25, 2011 at 2:48 pm
Carla Wilson-484785 (8/25/2011)
WayneS (8/25/2011)
Jack Corbett (8/25/2011)
Good article Wayne. Clear and concise examples.Thanks Jack.
I'm looking forward to the running totals ability.
Cool! Thanks...
August 25, 2011 at 9:25 am
HowardW (8/25/2011)
August 25, 2011 at 9:23 am
jcrawf02 (8/25/2011)
Nice job Wayne! So, assuming I understand this correctly, I can use the "Sliding Aggregations" to show a six-month trailing trend, or something similar?
Absolutely Jon - that is exactly...
August 25, 2011 at 8:23 am
Jack Corbett (8/25/2011)
Good article Wayne. Clear and concise examples.
Thanks Jack.
I'm looking forward to the running totals ability.
August 25, 2011 at 7:01 am
augustine.damba 67604 (8/24/2011)
Could you please verify that the Select statement and the Over() is correct for
SumByRows and SumByRange?
The Over() function is using same parameters but the results are different.
I have...
August 25, 2011 at 6:36 am
Jeff Moden (8/24/2011)
Fal (8/24/2011)
Jeff Moden (8/23/2011)
Stefan Krzywicki (8/23/2011)
Earthquake in CO yesterday and now one in VA that I felt all the way in Boston.
Hope everyone in the affected area is...
August 24, 2011 at 7:15 pm
Jack Corbett (8/24/2011)
SQLRNNR (8/24/2011)
Roy Ernest (8/24/2011)
We will just do reviews on the applicants for board...
August 24, 2011 at 2:17 pm
Well, good 'ole divide-n-conquer rules the day today. Optimized three processes today.
August 19, 2011 at 2:46 pm
Jeff Moden (8/18/2011)
Personally, I find that any splitter that "joins" with VARCHAR(MAX) is instantly twice as slow.
Maybe... but twice as slow as greased lightning is still lightning fast!
August 19, 2011 at 2:43 pm
Jeff Moden (8/19/2011)
GSquared (8/19/2011)
Jeff Moden (8/18/2011)
August 19, 2011 at 12:11 pm
Tom.Thomson (8/19/2011)
SQLRNNR (8/19/2011)
ALZDBA (8/19/2011)
That's the main reason why I +1-ed on both items.Ditto
Ditto too
+1 x 2
August 19, 2011 at 11:17 am
Ninja's_RGR'us (8/19/2011)
skrilla99 (8/19/2011)
...Ninja's_RGR'us Please post your results with the version(s) you tested on.
TIA.
2005 SP4 x86 - Same issue
http://www.sqlservercentral.com/Forums/FindPost1162490.aspx
-Dan B
Thanks again, that was the last big elephant in the room. ;-).
So...
August 19, 2011 at 8:07 am
Ninja's_RGR'us (8/19/2011)
August 19, 2011 at 8:06 am
Viewing 15 posts - 1,066 through 1,080 (of 5,590 total)