Viewing 5 posts - 106 through 110 (of 110 total)
Martin Schoombee (11/4/2011)[hrYour query also seem a bit strange. Why the "group by" when you are only returning an aggregate?
Opps! You're right! Apologies for this. I should've also included the...
November 5, 2011 at 5:06 am
cliffb (11/4/2011)
November 5, 2011 at 4:54 am
Lynn Pettis (11/3/2011)Save the actual execution plans as .sqlplan files.
OK, Here's the query:
SELECTCOUNT(Price)
FROMTempSales
GROUP BY Price
ORDER BY Price;
Here's the table:
CREATE TABLE TempSales
(
SalesID ...
November 3, 2011 at 11:45 am
GilaMonster (11/3/2011)
raotor (11/3/2011)
Great. Do you have any idea what sort of across-the-board performance increase I might expect by going 64-bit?
Little to none. 64-bit isn't about raw performance, it's...
November 3, 2011 at 7:19 am
bteraberry (11/2/2011)
It depends on what you want to do. You've given no indication as to the nature of what you want to accomplish
I am simply tinkering with SQL...
November 3, 2011 at 4:14 am
Viewing 5 posts - 106 through 110 (of 110 total)