Viewing 15 posts - 5,311 through 5,325 (of 8,415 total)
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
Gianluca Sartori (3/15/2010)
Maybe a limited OS like i-pad has would make things better. Or worse.
I am happy to trial (a free) one and report back 😀
March 15, 2010 at 9:01 am
Viewing 15 posts - 5,311 through 5,325 (of 8,415 total)