Viewing 15 posts - 5,311 through 5,325 (of 8,416 total)
Roust_m (3/15/2010)
The total memory grant for the whole query is also reported by the left-most node in the graphical execution plan from a real execution.
It looks like the plan...
March 15, 2010 at 10:42 pm
Les Cardwell (3/15/2010)
Since 'getdate()' is a non-deterministic function, like all non-deterministic functions, we've always assigned them to a scalar variable to ensure the dbms won't perform a table-scan...although admittedly, these...
March 15, 2010 at 9:59 pm
CirquedeSQLeil (3/15/2010)
As for the DVD's - I have heard mixed reviews.
Very helpful thanks! :unsure:
March 15, 2010 at 9:51 pm
mister.magoo (3/15/2010)
I think the results are to my mind "more random"
:blink: Really? 😉
There are some good points in your post, but I have to disagree with that one.
Your code is...
March 15, 2010 at 9:49 pm
Impending doom is never a good thing. :satisfied:
March 15, 2010 at 9:40 pm
No worries. I am glad we got there in the end. 🙂
March 15, 2010 at 9:38 pm
-- Test table
CREATE TABLE #Sample
(
column1 CHAR(1) NOT NULL,
...
March 15, 2010 at 9:36 pm
george sibbald (3/15/2010)
I'll keep banging my head overnight till I feel better. Tomorrow it goes.
Aw. I think it's awesome!
March 15, 2010 at 9:26 pm
GilaMonster (3/15/2010)
March 15, 2010 at 9:24 pm
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?DECLARE @selectDate DATETIME = getdate()-365
Offensive. Not just because it does not work with any of the new date/time types in...
March 15, 2010 at 9:21 pm
jwa082276 (3/15/2010)
Can you explain how to add the recompile hint for this procedure?
Erland covers the technique in depth in his article. The posted procedure does use dynamic SQL, it...
March 15, 2010 at 8:55 pm
GTR (3/15/2010)
Believe Max and Min is not necessary if you have SQL 64 bit, unless you want spend more time on this.
No this is quite wrong I'm afraid. You...
March 15, 2010 at 8:53 pm
Cyberspy (3/15/2010)
This sounds interesting. Any chance of an example?
Adam, this is something I get asked quite a lot, so I think I will write an article about it.
March 15, 2010 at 8:48 pm
Happy Existence Anniversary, Grant!
March 15, 2010 at 9:29 am
Viewing 15 posts - 5,311 through 5,325 (of 8,416 total)