Viewing 15 posts - 2,596 through 2,610 (of 2,645 total)
Site Visits Results
Summary
Three tests were run with different methods of calculating site visits.
1. Using a normal cursor - jacroberts
This took 29:36 to complete
2. Using a "pseudo" cursor - Jeff...
January 9, 2009 at 11:10 am
TheSQLGuru (1/5/2009)
January 5, 2009 at 9:49 am
The first bit of testing is finished. Firstly I am just testing the different initial queries to get the data. So no results from the cursors yet. I've had to...
January 5, 2009 at 8:35 am
Matt Whitfield (1/3/2009)
January 3, 2009 at 4:56 pm
Jeff Moden (1/3/2009)
jacroberts (1/3/2009)
I take is that @PrevKeep variable is redundant as it doesn't seem to be used?
BWAA-HAAA!!! Well, at least I know someone read the code. Yes...
January 3, 2009 at 2:12 pm
I take is that @PrevKeep variable is redundant as it doesn't seem to be used?
BWAA-HAAA!!! Well, at least I know someone read the code. Yes sir, I made...
January 3, 2009 at 1:49 pm
Jeff Moden (1/3/2009)
January 3, 2009 at 12:54 pm
Jeff Moden (1/3/2009)
jacroberts (1/2/2009)
January 3, 2009 at 11:03 am
Matt Whitfield (1/2/2009)
January 2, 2009 at 6:04 pm
Jeff Moden (1/2/2009)
January 2, 2009 at 3:44 pm
Jeff Moden (1/2/2009)
I agree... JacRoberts, would you provide the CREATE TABLE statement for the dbo.WebLogEvents table, please. From that, I'll make a million row table over a period of...
January 2, 2009 at 11:33 am
TheSQLGuru (1/2/2009)
January 2, 2009 at 9:50 am
Jeff Moden (1/2/2009)
Alexander Kuznetsov (12/24/2008)
January 2, 2009 at 9:34 am
battelofhalfwits (1/1/2009)
Also, when you say "Imagine scaling the cursor to tables with millions of rows". I'm imagining it! Are you sure that inserting the rows into a temporary table with...
January 2, 2009 at 2:26 am
Jeff Moden (1/1/2009)
One of my fellow MVP's... Go back and look at Grant's posts... you'll figure it out. I've probably said too much, already.
When you say "fellow MPV's" does...
January 2, 2009 at 2:22 am
Viewing 15 posts - 2,596 through 2,610 (of 2,645 total)