Viewing 15 posts - 44,191 through 44,205 (of 59,063 total)
It's so odd to hear everyone talking about getting "better" and not programming like they were in the '60's or '70's anymore. I wonder what people would say if...
April 12, 2009 at 9:10 pm
Sorry... had a change of thought... posted those thoughts further below.
April 12, 2009 at 8:55 pm
Bob Hovious (4/12/2009)
April 12, 2009 at 8:46 pm
GilaMonster (4/8/2009)
Steve Jones - Editor (4/7/2009)
GilaMonster (4/7/2009)
April 12, 2009 at 7:53 pm
GilaMonster (4/12/2009)
Alvin Ramard (4/12/2009)
Being a contractor, that would be without pay too
Same here. It comes out of my 'education and training' savings.
If you're paying your own way, ignore the conference...
April 12, 2009 at 7:45 pm
Paul White (4/12/2009)
You are so right to point out the data-consistency advantage of the computed column. I guess I could add a constraint or something to simulate that benefit,...
April 12, 2009 at 7:43 pm
sku370870 (4/12/2009)
SELECT #tblHolidays.HolidayDescription As [Description], #tblHolidays.HolidayDate AS [Holiday Date],
count(case #tblDepartmentHolidays.DepartmentID when 0 then 1 else null end) as [Global],
count(case #tblDepartmentHolidays.DepartmentID when 1 then 1 else...
April 12, 2009 at 7:38 pm
Heh... ok, Paul. From the way you were talking, I thought you were on to an improvement.
April 12, 2009 at 7:35 pm
Thanks for your concern. If I'm not mistaken, PIVOT can do multiple aggregations... I just gotta look back in my notes because I don't use PIVOT for all the...
April 12, 2009 at 7:25 pm
All of that may be true... I just hope they never remove the capability because it is an option. It's kind of like cursors... I generally deplore their usage...
April 12, 2009 at 7:52 am
Paul White (4/12/2009)
Jeff Moden (4/11/2009)
http://www.sqlservercentral.com/articles/T-SQL/63681/
Performance meaurements are at the bottom of...
April 12, 2009 at 7:39 am
Paul White (4/11/2009)
Jeff Moden (4/11/2009)
...A persisted computed indexed column would do very nicely here.
Hey Jeff,
It would, but an ordinary column would be my first choice, mainly because persisted computed columns...
April 12, 2009 at 7:36 am
Outstanding... thanks for the post and the code, Paul... I'll check it out. That's what I love about forums. Lots of folks with lots of ideas.
April 12, 2009 at 7:31 am
Bob Hovious (4/11/2009)
April 11, 2009 at 9:27 pm
I agree... it would probably be better to not move the data before processing. And, if that's still somehow necessary, I've had great success with just dropping the table...
April 11, 2009 at 8:15 pm
Viewing 15 posts - 44,191 through 44,205 (of 59,063 total)