Viewing 15 posts - 32,491 through 32,505 (of 59,102 total)
Thanks for the great explanation and, I agree... the control loop for this would not be a performance problem. As a sidebar, man, I'd love to take a crack...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 24, 2011 at 6:28 pm
R.P.Rozema (9/23/2011)
Hi Jeff, did you find some time to work on some examples for us on nested sets?
It would appear that Mr. Celko has some examples at the ready and...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 24, 2011 at 5:52 pm
Thanks, Marilu. Those are a pair of awesome compliments. "Miss Liberty" is one of my favorite "people" and it was my pleasure to serve.
Heh... having a bit...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 24, 2011 at 4:36 pm
GilaMonster (9/24/2011)
That's one nice thing about been a consultant.
Heh... and, oh, how I miss that. And, yes... I agree... the wrong people would read the book. After all,...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 24, 2011 at 4:25 pm
Whereas there are plenty of experts prepared to help with the technology, few seem to come forward when the struggle is against the bureaucracy rather than a recalcitrant server.
I have...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 24, 2011 at 1:49 pm
majorbloodnock (9/23/2011)
For me, the following are major gaps I see, often in surprisingly senior IT people.
Understanding what it...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 24, 2011 at 1:06 pm
Which edition of SQL Server do you have? Also, any chance of you posting the code for your reindex job... sanitized, of course.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 24, 2011 at 12:14 pm
On of the easiest ways to do this, and it will capture any and all changes, is to do as suggested above but use some very well written triggers (and...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 24, 2011 at 12:04 pm
You say these tables are also used for reporting? If THIS particular table is used for reporting, there's a fairly good chance it has some indexes on them that...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 24, 2011 at 11:31 am
bennett_js (9/23/2011)
SELECT PWARD_EQUIPMENT.EQUIPMENT_ID, PWARD_EQUIPMENT.AMMO_QUANTITY AS QUANTITY_ON_HAND,
SUM(PWARD_AMMO_USE_EQUIPMENT.QUANTITY_USED) AS QUANTITY_USED, SUM(PWARD_EQUIPMENT.AMMO_QUANTITY + QUANTITY_USED) AS QUANTITY_RECEIVED
FROM ...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 24, 2011 at 11:09 am
CELKO (9/23/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 24, 2011 at 9:45 am
I apologize for the delay but yes, indeed, I am doing some testing in my "spare" time. This has become quite interesting.
Conventional wisdom would indicate that a single "SUM"...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2011 at 7:39 pm
Mike M - DBA2B (9/23/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2011 at 4:05 pm
mkeast (9/22/2011)
You have been deserving of an award like this for years. As a long-time SSC member and regular tally table user (and calendar table!), I thank you...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2011 at 5:57 am
L' Eomot Inversé (9/22/2011)
Great interview, Jeff.And congratulations again on the award.
Thanks again, Tom. And don't you ever even think about quitting. Your posts and advice have been quite...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2011 at 5:39 am
Viewing 15 posts - 32,491 through 32,505 (of 59,102 total)