Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • RE: Issues and performance of importing XML into SQL Server 2008

    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...

  • RE: Issues and performance of importing XML into SQL Server 2008

    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...

  • RE: Issues and performance of importing XML into SQL Server 2008

    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,...

  • RE: XML Bulk Load Problem

    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...

  • RE: Snowflaking Dimensions

    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)....

  • RE: Snowflaking Dimensions

    ssills (2/9/2011)


    Looks to me as if there are two fact tables: policies and transactions, both have agent relationships. The former is SCD. The latter probably isn't. Whether broker may or...

  • RE: Snowflaking Dimensions

    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...

  • RE: Snowflaking Dimensions

    PaulB-TheOneAndOnly (2/9/2011)


    1.a - I do agree a DimAgent dimension table is needed.

    1.b - How about having two FactPolicyTransaction columns named AgentPolicy and AgentTransaction.

    I assume FactPolicyTransaction table will be sliced and...

  • RE: Sins of SQL: The Time Table

    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,...

  • RE: Part 2: Why you should be using the Full Recovery Model

    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...

  • RE: Part 2: Why you should be using the Full Recovery Model

    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...

Viewing 11 posts - 1 through 11 (of 11 total)