Viewing 15 posts - 4,561 through 4,575 (of 8,416 total)
tom.newman 88696 (3/31/2010)
I see what your saying and it makes sense.... I will proceed with the reading!! thanks
No worries. If you come across anything that puzzles you, post something...
March 31, 2010 at 6:53 am
Chris Morris-439714 (3/31/2010)
Paul White NZ (3/31/2010)
HR read your posts???SSC HR...
Really? Wow! I feel decidedly left out now 🙁
You must have used some really, er, enthusiastic language.
You are a...
March 31, 2010 at 6:52 am
James Lean (3/31/2010)
March 31, 2010 at 6:49 am
Hugo Kornelis (3/31/2010)
So if any of the arguments is a subquery, the implementation if COALESCE((subquery), ...) becomes CASE WHEN (subquery) IS NOT NULL THEN (subquery) ... ELSE NULL END.
That reminds...
March 31, 2010 at 6:44 am
Kwisatz78 (3/31/2010)
Its SQL 2005 Enterprise 64bit, and there a various clients running on the machine as well as SQL.
Ok, so maybe start off conservatively with a max server memory setting...
March 31, 2010 at 6:10 am
Tom.Thomson (3/31/2010)
Paul White NZ (3/30/2010)
Not my lucky day.
That sounds as if you got it wrong. I can't resist asking which error did you make:
a) 11 is an even number;...
March 31, 2010 at 6:05 am
Chris Morris-439714 (3/31/2010)
March 31, 2010 at 5:42 am
tom.newman 88696 (3/31/2010)
...joins create virtual tables which is a combination of both tables, then filtered down.
Only logically. Can you imagine how slow queries against large tables would be if...
March 31, 2010 at 5:35 am
matt32 (3/31/2010)
WITH mycte AS (SELECT cast ('2007-01-01' AS DATETIME) DateValue UNION ALL SELECT DateValue + 1...
March 31, 2010 at 5:26 am
Chris Morris-439714 (3/31/2010)
Ooh don't...one of those really ticked me off a few weeks ago :blush:
Grates on me like fingernails on a blackboard. Did you vent on-thread? Link please!
Never...
March 31, 2010 at 3:04 am
Jack Corbett (3/30/2010)
Paul White NZ (3/30/2010)
CirquedeSQLeil (3/30/2010)
That to me is akin to calling PaulPaulster
Never do that again. I will find you. :w00t:
A little intense there hey, Paulie? 😀
Don't...
March 31, 2010 at 3:01 am
Are you planning to do something that requires loading one million rows into a temporary object or one kind or another?
You should probably forget about the distinction between RAM and...
March 31, 2010 at 2:59 am
A (non-recursive) CTE is exactly equivalent to a derived table in the FROM clause - it is not a 'real' table.
Perhaps an example will help. The following two queries...
March 31, 2010 at 2:54 am
Raju The Leader (3/31/2010)
March 31, 2010 at 1:56 am
vk-kirov (3/31/2010)
Nice find, thank you. So, if it barks like a dog, it behaves like a dog, what is it?...
It is a duck, with some arguably dog-like features 😛
March 31, 2010 at 1:52 am
Viewing 15 posts - 4,561 through 4,575 (of 8,416 total)