Viewing 15 posts - 16 through 30 (of 37 total)
I have received the following reasonably definitive response. Oh, well. It was worth a shot...
[Y]ou have hit on an important point about trying this approach. Because you...
Larry
October 19, 2004 at 11:18 am
Not sure I understand the first question - "how do I get to them?" If the locations are fixed and you simply want to cycle through all files (perhaps with...
Larry
September 13, 2004 at 8:19 am
My answer depends upon what you mean by "scalability." If you mean number of users, I have not seen a problem directly as a result of number of users since...
Larry
July 23, 2004 at 8:33 am
Andy,
I feel compelled to reply. 64-bit was our salvation for our OLAP performance problems. The pain we felt during the week it took to convert our 40+ packages to a DTS-DB...
Larry
February 27, 2004 at 6:58 am
I could have sworn someone showed an example of such code at SQLPASS in a talk on DTS best practices. Anyone remember that?
Larry
February 26, 2004 at 11:29 am
We were hit with the same rude surprise when we migrated. Short version - keep DTS on 32-bit. It might run, but you are on your own if you do...
Larry
February 26, 2004 at 11:26 am
Depending upon the environment, our DB, OLAP, DTS, logging, and files used may be placed on a single box, all on separate boxes, or somewhere in between. I wish I could say...
Larry
February 26, 2004 at 11:13 am
It depends upon what your goal is.
Because our development, QA and production environments differ greatly in configuration, we started putting a set of dynamic properties and ActiveX tasks at the...
Larry
February 26, 2004 at 7:37 am
At SQLPASS, I was told that Yukon is supposed to have "real" partitioning, in which the partitions can be managed individually, taken on/offline, etc.
Larry
Larry
January 23, 2004 at 8:12 am
This sounds like it could be handled in a stored procedure. Check for dups in a SQL statement in the procedure. If they exist, call another stored procedure to email...
Larry
January 13, 2004 at 8:07 am
Well, you can - sort of. You can do looping using ActiveX script to play with the status of the steps. Check out or http://www.sqldts.com/?246 for a good example. If...
Larry
January 12, 2004 at 9:01 am
We selectively turn it off for certain ugly queries.
We have one system that has double-digit millions of rows in each of 36 (and growing) partitions of a union partitioned...
Larry
January 9, 2004 at 7:16 am
From the "announcement" email:
QUOTE:
It is with great please that I announce an updated version of the PPU (V3) is now live.
See the attached readme.doc file for all of...
Larry
January 5, 2004 at 10:06 am
Okay - way out on a limb - no time to fact check, you assume all risk, etc.
As I recall, all OLAP tasks "execute on the main package thread", so...
Larry
December 31, 2003 at 9:28 am
Why should this surprise anyone? Any large production system is usually treated with great care. As Patrick mentioned, the answer many DBAs default to is "NO!" regardless of...
Larry
December 12, 2003 at 8:13 am
Viewing 15 posts - 16 through 30 (of 37 total)