Viewing 11 posts - 1 through 11 (of 11 total)
If you can take the XML and actually turn it into a well formatted and normalized text file, you should have avoided XML in the first place.
With that...
October 7, 2015 at 8:51 pm
XML structure that goes more than 2 levels deep performs horribly with SSIS during the development cycle. Drop-downs where you are picking a node could take minutes, and even...
September 28, 2015 at 8:27 am
TedT,
It ran horribly from the command line as well. After taking steps to eliminate memory issues by putting the code that processes an XML doc into its own package,...
January 31, 2012 at 4:16 pm
Figured it out. It had to do with the fact that the bulk loader isn't pleased with the fact that the type Monetary was a union of two member...
August 12, 2011 at 7:08 am
ERD of your Data Warehouse - Star schema has to be based in something.
I'm definitely missing something (which, of course, is off topic). The data warehouse IS the star schema(s)....
February 10, 2011 at 9:51 am
ssills (2/9/2011)
February 9, 2011 at 4:00 pm
The use of Data Warehouse to get a "list of brokers" is not what Data Warehouse is meant for, that information should be provided by the OLTP system, nobody analyzes...
February 9, 2011 at 2:35 pm
PaulB-TheOneAndOnly (2/9/2011)
1.b - How about having two FactPolicyTransaction columns named AgentPolicy and AgentTransaction.
I assume FactPolicyTransaction table will be sliced and...
February 9, 2011 at 1:06 pm
To play devils advocate, if you were to split the date and time into two dimensions, the calculation for summing all transactions between Jan 10, 2010 3:00PM and Jan 14,...
June 1, 2010 at 5:12 pm
Jeffrey - thanks for the reply. Won't BackupExec or the other major backup products out there back up "open files"?
Jeffrey Williams-493691 (9/21/2009)
You cannot backup the mdf/ldf file while SQL...
September 21, 2009 at 3:19 pm
For those that use "simple" recovery model, when it comes to backups, does it matter if you are doing full backups or simply backing up the .mdf/.ldf files? Wouldn't...
September 21, 2009 at 10:25 am
Viewing 11 posts - 1 through 11 (of 11 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy