Viewing 15 posts - 241 through 255 (of 264 total)
urgh that does not format well...
basically the query is the same but
cpu goes from 1109 to 48265
reads goes from 78843 to 9400939
writes goes from 0 to 801
duration increases...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
November 8, 2010 at 7:34 am
OK, done that.
Trace Start2010-11-08 14:29:09.033
SQL:BatchStartingSELECT dbo.funTotalQuotesHhi('08 Nov 2010','01 Nov 2009','30 Nov 2009')
Microsoft SQL Server Management Studio Express - QuerywardbFORTIS-UK\wardb5336542010-11-08 14:29:16.793
SQL:BatchCompletedSELECT dbo.funTotalQuotesHhi('08 Nov 2010','01 Nov 2009','30 Nov 2009')
Microsoft SQL Server Management...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
November 8, 2010 at 7:32 am
interesting...
this returns the correct number of rows but takes twice as much time as my original query.
funny how queries work differently in different circumstances/tables eh!
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
October 29, 2010 at 8:08 am
Chris Morris-439714 (10/29/2010)
SwePeso (10/29/2010)
SELECTSUM(1) AS Items
FROMdbo.tblHhiQuotes
WHERE sGlDate <= '28 Oct 2010'
AND sEffectiveDate BETWEEN '01 Nov 2010' AND '30 Nov...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
October 29, 2010 at 7:17 am
erm....
Msg 8155, Level 16, State 2, Line 6
No column was specified for column 1 of 'd'.
:Whistling:
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
October 29, 2010 at 5:30 am
And the results are in !
My query was the slowest (as was expected lol)
most common speed 156ms with a low of 141 and a high of 196
3rd place goes...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
October 29, 2010 at 4:05 am
you
are
a ...
😀
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
October 28, 2010 at 8:49 am
I did try rollup, that just gave extra records.
I'll give that a read...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
October 28, 2010 at 6:47 am
haha yes
which is (I think) exactly the same as
;WITH cteSource(Data)
AS (
SELECT 1
...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
October 28, 2010 at 5:18 am
thats brilliant thanks.
I'm surprised there isnt an alternative version of count in sql server that returns the number of rows like a numrows() function or whatever.
Thanks
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
October 28, 2010 at 4:25 am
Hi Chris,
thats essentially what I'm doing but twice.. im trying to call that sproc from another and copy data into a table from that exec which sql cant do.
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
September 21, 2010 at 10:01 am
Hi Dan,
Thanks for reply, I'm using xp_cmdshell in order to kick off dtsx packs and use php to odbc to informix and perform some complex logic that I really really...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
September 21, 2010 at 9:58 am
Thanks Oliii!
I had a look at the steps details and found the tickbox to export to table but couldn't see where/how to specifiy what table to output to! I'll have...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
September 17, 2010 at 2:41 am
oooh I had not realised this! Thanks!
dont suppose anyone has a tutorial at all? if not I'll google for a bit 🙂
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
September 17, 2010 at 2:20 am
Thanks Buddy,
That's really useful!
Still wondering about the 'x rows affected' stuff but this is very helpful 🙂
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
September 17, 2010 at 1:46 am
Viewing 15 posts - 241 through 255 (of 264 total)