Viewing 15 posts - 1 through 15 (of 33 total)
Do not forget the bandwidth of the PCI bus.
Do not forget the availability of multiple I/O channels in the controller and whether or not any MPIO load balancing is used.
In...
July 26, 2011 at 11:17 am
What you have to keep in mind is that DTS and MPW are NOT the same thing, but SS2K5, and beyond, has chosen to integrate the tasks, not the schedules.
If...
October 10, 2008 at 6:54 am
These difficulties are due to the need for backwards compatibility and the new architecture. If you examine an SS2K5 (or SS2K8, for that matter) MSDB database, you will notice...
October 9, 2008 at 6:02 am
Basically, yes, but even in SS2K you might have needed to use the DTS Designer to modify package connections if you used "(local)" and/or logged package executions locally.
It is a...
July 23, 2008 at 10:19 am
First of all, DTS (and/or SSIS) packages are just that, packages. They can be saved to a code file, a proprietary file (.dts or .dtsx), or saved in the...
July 22, 2008 at 3:46 pm
You must keep in mind that only the SS2K maintenance plans are stored in the maintenance plans MSDB system tables as legacy object.
The new SS2K5 maintenance plans are modified SSIS...
July 22, 2008 at 12:05 pm
I think we just need better questions, for example:
In SQL Server 2005, what is the preferred way to update LOB data?
In this case, you would need to know that the...
June 16, 2008 at 12:54 pm
Once, we had a round-table database design question with the Senior IT leadership, based on this exact topic, data integrity and RI versus the development effort surrounding a MUCK design—yes,...
July 24, 2006 at 12:59 pm
Well, that could certainly spawn off into a whole other argument: using relational or dimensional warehouse structures.
E-gad.
Anthony Thomas
July 24, 2006 at 12:01 pm
It sounds like you've got a pretty good handle on the operatioanl components, but the drudgery of the reporting is what you are finding the MUCK solution for.
I'm not sure...
July 24, 2006 at 10:56 am
You are absolutely correct, the Business Model rules because it is the model that contains all of the business requirements.
The Data Model models the data about which we describe the...
July 23, 2006 at 10:17 pm
As much as I would like to agree with you, the posts here are not at all uncommon from those I work with, and, unfortuanately, more often than not, they...
July 23, 2006 at 6:28 pm
Couldn't agree more.
A good article, but the subsequent discussion has pretty much run its course.
Sincerely,
Anthony Thomas
July 23, 2006 at 1:01 pm
I agree that this gets old, but isn't this a public forum? If some are allowed to write this dribble, then aren't others allowed to respond? And, the dribble keeps...
July 22, 2006 at 10:42 am
What in the world is that garbage: "optimize for flexibility," "optimize for speed." Try this one out for a change. How about "optimize for correctness and integrity."
You tell me, is...
July 21, 2006 at 7:56 pm
Viewing 15 posts - 1 through 15 (of 33 total)