Viewing 15 posts - 811 through 825 (of 4,080 total)
Good lord, a blast from the past.
John, have you discovered actual documentation for DBCC TIMEWARP?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 21, 2012 at 12:34 pm
ScottPletcher (9/7/2012)
If you want precise control over shortening the results returned from a float column, there is always the ROUND() function.
If you want precise values, just use decimal to begin...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 18, 2012 at 4:31 pm
I'm compelled to ask WHY you even feel the need to ltrim(rtrim()) floating point columns. Did you think they might have leading or trailing spaces?
Gail has...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 7, 2012 at 4:12 pm
GilaMonster (8/24/2012)
It's potential energy is negative to the entire universe.
WHICH entire universe?
How about:
It's so low that it's at the bottom of every universe in the many-worlds interpretation.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2012 at 10:17 pm
Lynn Pettis (8/6/2012)
SQLRNNR (8/6/2012)
Lynn Pettis (8/6/2012)
The Dixie Flatline (8/6/2012)
In that case I respectfully decline to volunteer.
It has to be a Monday, my mind immediately hit the sewer when I read...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 7, 2012 at 9:40 am
CTEs actually do operate like views, they just don't persist for more than one query.
They are used like subqueries (or derived tables). But...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 6, 2012 at 8:18 pm
In that case I respectfully decline to volunteer.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 6, 2012 at 5:45 pm
The optimizer is choosing to scan the lookup table because it thinks that is the fastest way for it to deliver the data. Consider that for...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 6, 2012 at 5:39 pm
Define "take care of"....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 6, 2012 at 5:13 pm
New year, same homework assignments?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 4, 2012 at 11:56 am
Whenever you use NULL in an expression, the result is NULL.
A CASE statement should also work here.
SELECT Test, CASE WHEN Test = '?' THEN NULL ELSE Test END
FROM #Test
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 30, 2012 at 10:07 pm
RBarryYoung (5/24/2012)
Is it my imagination or is Paul getting younger?😀
Maybe he was experimenting with DBCC TIMEWARP and accidentally restored a backup copy of himself...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 25, 2012 at 7:14 am
Lynn Pettis (5/23/2012)
AAARRRRRGGGGGGG!!!!!!!Really, he just needs to go away. He isn't helpful at all.
Hi, Lynn.
I'm enjoying a cruel chuckle at your expense. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 24, 2012 at 3:01 pm
Let me test it and see. Thanks, Ben!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 24, 2012 at 11:38 am
Gianluca Sartori (5/22/2012)
If everything goes well, I won't be working as a trainer any more.
I'm negotiating a contract as DBA/DBD. It's going to be...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 23, 2012 at 5:06 pm
Viewing 15 posts - 811 through 825 (of 4,080 total)