Viewing 15 posts - 9,301 through 9,315 (of 14,953 total)
Did you modify the query at all?
Having Datepart(hour) in the Group By should make it just return the hours. I just tested that, and it worked:
create table #T (
ID...
June 9, 2009 at 3:01 pm
Seems like a reasonable use of BI tech. Heuristic, self-correcting systems like that can work.
I built one that predicted whether a customer would stay or leave, and it was...
June 9, 2009 at 2:54 pm
I can just see it now: After detailed studies, it turns out that the CLR triggers all come from one dev database on one server, being used for proof-of-concept testing,...
June 9, 2009 at 2:29 pm
Can you post both execution plans? Can't really figure out the difference without looking at those.
June 9, 2009 at 2:22 pm
I'm assuming you mean something besides kilobytes when you say "15k" on the hard drives, but I'm not sure what. Could be RPM, but I'm not used to that...
June 9, 2009 at 2:18 pm
Why not simplify the whole thing by doing something like this:
SET @reportDate = '2009-01-10 00:00:00.000' --hard coded date for now
SELECT
sr.SiteName,
b.BldgName...
June 9, 2009 at 2:13 pm
I just got sucked into the complexity discussion.
"We're caught in a tractor beam..."
June 9, 2009 at 1:59 pm
He's talking about memory allocation. I don't know how T-SQL handles variable buffers and such, but in C, you would actually rewrite the memory addresses (or at least, you...
June 9, 2009 at 1:58 pm
Lynn Pettis (6/9/2009)
Could just be me, but I still think our PhD Candidate doesn't have a clue.
Of course not! Don't you know what BS, MS, PhD stand for? ...
June 9, 2009 at 1:55 pm
Karthik, '1'+'2' is still O(n^2). What's 1 squared?
June 9, 2009 at 1:52 pm
Steve Jones - Editor (6/9/2009)
June 9, 2009 at 1:01 pm
You definitely can do that. Really, the only difference is making sure that you set up logins for the shipping that allow you to connect and do what you...
June 9, 2009 at 12:40 pm
GilaMonster (6/9/2009)
From experience I've found that fixing the 3 top performance problems in the DB often provides an incredible improvement in overall response and performance
Ditto. It's a ripple effect.
June 9, 2009 at 12:39 pm
After reading your description, I'd go with what Barry suggested. I'd also suggest moving it from a trigger into the insert proc, if that's possible. Makes for much...
June 9, 2009 at 12:38 pm
I'd go with specialized indexes. The gain from those should much more than offset the loss of maintaining them.
Like Gail said, pick the most common queries, add covering indexes...
June 9, 2009 at 11:41 am
Viewing 15 posts - 9,301 through 9,315 (of 14,953 total)