May 14, 2009 at 11:13 am
Jeff Moden (5/14/2009)
Steve Jones - Editor (5/13/2009)
Ahhh, Klingons asking questions. About databases? Could be interesting....Heh... still not as bad as some of the questions folks ask on the forums. 😀
Steve Jones - Editor (5/14/2009)
Might not be any different questions 😉
Heh. Might not be any different "folks". 😀
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 14, 2009 at 1:25 pm
Sql Server DBA with 4 Hrs of experience. Thats a strange experience... 🙂
-Roy
May 14, 2009 at 1:30 pm
Roy Ernest (5/14/2009)
Sql Server DBA with 4 Hrs of experience. Thats a strange experience... 🙂
At least he didn't say Senior SQL DBA
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 14, 2009 at 1:50 pm
On Qo'noS, none rise to the rank of Klingon Senior DBA except over the bloody bodies of their fallen predecessors.
__________________________________________________
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 14, 2009 at 1:56 pm
Bob Hovious (5/14/2009)
On Qo'noS, none rise to the rank of Klingon Senior DBA except over the bloody bodies of their fallen predecessors.
Me thinks Bob's gone off the deep end!
Bob, relax, you don't have to sing tonight. Meeting moved to next week.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 14, 2009 at 2:08 pm
Regarding the post referenced at http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/5853c544-42d1-415e-9f65-29b5286fc21e ,can someone post this alternative solution ?
The posed solution specified uses 3,346 ms of CPU time but this solution uses 375 ms.
DECLARE @ChannelId tinyint
, @Value float
, @BeforeTs datetime
set @ChannelId = 1
set @Value = 0.5
set @BeforeTs = cast ( '2009-01-01 05:33:19.950' as datetime )
select *
FROM (SELECT ExceededTs
, MAX (ChannelData.[TimeStamp] ) as UnderTs
from dbo.ChannelData
join (select MAX ( ChannelData.[TimeStamp] ) as ExceededTs
from dbo.ChannelData
where ChannelData.ChannelId = @ChannelId
and ChannelData.[TimeStamp] @Value
) as Exceeded
on ChannelData.ChannelId = @ChannelId
and ChannelData.[TimeStamp] < ExceededTs
and ChannelData.Value < @Value
GROUP BY ExceededTs
) as Channel
JOIN dbo.ChannelData as ChannelExceeded
on ChannelExceeded.ChannelId = @ChannelId
and ChannelExceeded.[TimeStamp] = Channel.ExceededTs
JOIN dbo.ChannelData as ChannelUnder
on ChannelUnder.ChannelId = @ChannelId
and ChannelUnder.[TimeStamp] = Channel.UnderTs
SQL = Scarcely Qualifies as a Language
May 14, 2009 at 2:10 pm
Wow! At ten posts per page, mine would be Four Thousand, Four Hundred, and Forty-Two! Woohoo!
Gaby
________________________________________________________________
"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein
May 14, 2009 at 2:11 pm
Sorry, Alvin. I went to see the new Star Trek movie for a second time last night. 😀
For the record, I don't play the banjo and my singing voice is "questionable."
__________________________________________________
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 14, 2009 at 2:14 pm
Gaby Abed (5/14/2009)
Wow! At ten posts per page, mine would be Four Thousand, Four Hundred, and Forty-Two! Woohoo!
Make it: Four Thousand, Four Hundred, and Forty-Four! 4444!
LOL, not that I'm worried that this thread will die or anything.
Gaby
________________________________________________________________
"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein
May 14, 2009 at 2:16 pm
Gaby Abed (5/14/2009)
Wow! At ten posts per page, mine would be Four Thousand, Four Hundred, and Forty-Two! Woohoo!
At least I can say that my signing voice is NOT questionable. It's horrible!
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 14, 2009 at 2:32 pm
Bob Hovious (5/14/2009)
On Qo'noS, none rise to the rank of Klingon Senior DBA except over the bloody bodies of their fallen predecessors.
And that's different from current-day corporates how?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 14, 2009 at 2:40 pm
GilaMonster (5/14/2009)
Bob Hovious (5/14/2009)
On Qo'noS, none rise to the rank of Klingon Senior DBA except over the bloody bodies of their fallen predecessors.And that's different from current-day corporates how?
On Qo'noS, it is done in open combat with bat'leth and honed execution plans.
Corporate assasinations are without honor.
__________________________________________________
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 14, 2009 at 3:43 pm
Proudly present my personal hall of blame #1:
:pinch:
How to Post Data/Code to get the best Help How to Post Performance Problems
May 14, 2009 at 3:58 pm
Get some sleep, Flo! Wake up in the morning and have more coffee.
Tomorrow is another day. 😀
__________________________________________________
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 14, 2009 at 8:40 pm
Carl Federl (5/14/2009)
Regarding the post referenced at http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/5853c544-42d1-415e-9f65-29b5286fc21e ,can someone post this alternative solution ?
Done.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 15 posts - 4,426 through 4,440 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply