Viewing 15 posts - 1,111 through 1,125 (of 8,416 total)
aitchkcandoo (1/16/2012)
OK. I will do that.
Well it's a bit late now 🙂
Remember it for your next question. Better question = betetr, faster answer
I just stumbled on another solution taken...
January 16, 2012 at 2:08 am
That is a recursive CTE. You can find a detailed explanation of how your example query plan executes here:
http://blogs.msdn.com/b/craigfr/archive/2007/10/25/recursive-ctes.aspx
http://blogs.msdn.com/b/craigfr/archive/2007/11/07/recursive-ctes-continued.aspx
January 16, 2012 at 1:31 am
READUNCOMMITTED (aka NOLOCK) is indeed inappropriate if you are looking for anything other than a best-effort quick view of the data. Beware of falling into the trap of thinking...
January 16, 2012 at 1:26 am
aitchkcandoo (1/15/2012)
January 16, 2012 at 1:20 am
Just to add a little detail:
CREATE TABLE Student
(
StudentID INT IDENTITY(1,1) PRIMARY KEY,
StudentName VARCHAR(25) NOT NULL UNIQUE
) ;
CREATE TABLE Course
(
CourseID INT IDENTITY(1,1) PRIMARY KEY,
CourseName VARCHAR(15) NOT NULL UNIQUE
)
CREATE TABLE Student_Course
(
StudentID INT...
January 16, 2012 at 1:10 am
Hugo Kornelis (1/16/2012)
Can you please drop this? You are now both reiterating the same point again and again.
Sergiy has made his point that he disagrees with the...
January 16, 2012 at 12:46 am
Sergiy (1/15/2012)
Fun part: Question: Which query plan operator executes first? Correct answer: The Stream Aggregate
Thank goodness!
My question: Sorry, the Stream Aggregate executes what?
First! 😀
January 16, 2012 at 12:26 am
Sergiy (1/15/2012)
Which means - Fuel counting executes before fuel is pumped.
The part that resets the counter does, yes. Of course, the total amount of fuel pumped is only shown...
January 16, 2012 at 12:24 am
Step-by-step guide to the method I used:
DECLARE @Trading TABLE
(
ID integer NOT NULL PRIMARY KEY,
[Date] date NOT NULL,
[Time]...
January 15, 2012 at 11:17 pm
Jeff Moden (1/15/2012)
Agreed, although it's difficult to include such generated data (million rows) in a post or an article. 😀
A script is certainly compact, but using NEWID means the data...
January 15, 2012 at 10:56 pm
Sergiy (1/15/2012)
How happy are those people about this one: Cursor loop executes before the first row of the cursor is fetched? Or Main routine executes before any of its subroutines?
You...
January 15, 2012 at 10:37 pm
Sergiy (1/15/2012)
Both fuel counter and row counter are reset before the counted substance is being delivered.Just proves the analogy is correct.
So the fuel counter executes first, cool. The analogy...
January 15, 2012 at 10:33 pm
Sergiy (1/15/2012)
So, TOP contunues to request rows until it's fed up.
I know how it feels 😉
That's why it's totally wrong to say that operator TOP executes first. If you...
January 15, 2012 at 10:28 pm
Sergiy (1/15/2012)
The fact is - the question should be not about what is executed first, but what is dependency relation between the routines.
So write your own question about that. ...
January 15, 2012 at 10:19 pm
Sergiy (1/15/2012)
January 15, 2012 at 10:16 pm
Viewing 15 posts - 1,111 through 1,125 (of 8,416 total)