Viewing 15 posts - 2,266 through 2,280 (of 3,348 total)
Sergiy (1/12/2012)
JOIN is executed (eliminating the extra row) BEFORE aggregation even starts to evaluate any upcoming values.
Yes - before aggregation starts to evaluate any upcoming values. But after it starts...
January 13, 2012 at 12:54 am
Sergiy, I decided not to repeat comments already made by Paul. But here is a point he did not yet address, so allow me to do so:
Sergiy (1/12/2012)
January 13, 2012 at 12:37 am
Sergiy (1/12/2012)
As soon as you run this command the procedure (query) is parsed.
After parsing is completed optimiser looks for an execution plan (compiled code) for the SQL batch.
If it cannot...
January 12, 2012 at 5:14 pm
I think the problem is lingual.
"Is executed" can have two meanings.
1. Present tense, passive form - the code is invoked. Can be compared to running "EXEC MyStoredProc" in SQL Server....
January 12, 2012 at 4:09 pm
Sergiy (1/12/2012)
Simple question:what's being aggregated if the data in the table have not been scanned yet?
Most operators don't process all data at once; they are called repeatedly with the...
January 12, 2012 at 3:13 pm
The benefit of storing it in a single column is that you can now easily compare two time stamps. With two columns, questions such as "is Jan 10 2012, 8:43...
January 10, 2012 at 12:50 am
codebyo (1/6/2012)
What are the main advantages of using a backup compression over using a normal backup file with 7zip or WinRar?
Native backup compression is a single-step process; normal backup followed...
January 7, 2012 at 3:23 am
SQL Kiwi (1/5/2012)
I need to look at it a bit more closely to understand fully what the script is telling me
I didn't disect it completely, or even execute it, but...
January 5, 2012 at 8:06 am
nigel. (1/4/2012)
Thanks for the clarification, but the following case does not seem to match your explanation, (or have I misunderstood?)
SELECT CAST( '.' AS numeric)fails with 'Error converting...'
That surprises me! (Yes,...
January 4, 2012 at 10:36 am
Thanks for the question, Stuart!
To expand a bit on the explanation, ISNUMERIC determines if a string value can be converted to a numeric data type - any numeric data type....
January 4, 2012 at 2:26 am
L' Eomot Inversé (1/3/2012)
January 3, 2012 at 7:51 am
OOPS!! Sorry, Paul - you are completely right.
I had missed the rounding of the decimal result; I thought that the decimal result was the exact and correct result. Even when...
January 3, 2012 at 3:43 am
Happy new year everyone! 😉
It doesn't happen very often, but today I find myself in disagreement with Paul. The correct answer is (or should be) DECIMAL.
The "precision" mentioned on the...
January 3, 2012 at 3:11 am
Jeff Moden (1/1/2012)
Tom Brown (12/31/2011)
Keep 'em coming. ...
January 1, 2012 at 8:07 am
I wish everyone a great New Year's Eve - if you want to set off fireworks, please do so with care; in our profession, less fingers means less work done...
December 30, 2011 at 1:09 am
Viewing 15 posts - 2,266 through 2,280 (of 3,348 total)