Forum Replies Created

Viewing 15 posts - 16 through 30 (of 87 total)

  • RE: Indexing Joined Columns

    Hey, any new techniques you could share would be awesome. You actually helped me come up with the one I'm using on another thread. Anyway, here goes. For each day,...

  • RE: Indexing Joined Columns

    I'm comparing people's scheduling and time punch data, which often do not match. I need to define the amount of time they worked when scheduled, worked when not scheduled, and...

  • RE: Indexing Joined Columns

    Thanks Jeff! You're the man!

    Well, these temp tables can get to be about 100 million+ records, so maybe I'll just create physical tables in the db, populate these staging tables, index...

  • RE: Indexing Joined Columns

    Well, I do use it as follows:

    CREATE

    TABLE #ScheduleVariance (PersonNum varchar(15),ComplianceDate

  • RE: HELP Eliminating this cursor?

    Thanks so much for all the great replies! Awesome! Here's the whole script. What do you guys think? Any changes you might suggest? Indexing maybe? Thanks!

    If

  • RE: HELP Eliminating this cursor?

    WOW!!! Thanks guys! Let me play around with these a little bit.

    Thanks so much for the quick replies!

    Pat

  • RE: HELP! UPDATE QUERY won''''t complete!

    no, lagcategory isn't in any of the indexes. takes aboout 1/2 hour to load the data.

  • RE: HELP! UPDATE QUERY won''''t complete!

    no, i actually recreated the table to be sure it was blank and same result...

  • RE: HELP! UPDATE QUERY won''''t complete!

    it's loaded each week, and I have no control over the data source it comes from (SAS in this case)...i wish...

  • RE: HELP! UPDATE QUERY won''''t complete!

    Thanks guys. the indexes are dropped and recreated each load. the lagcategory field is always blank.

    i don't know what happened that changed the update time so drastically. it's driving...

  • RE: Data Conversion Failed Importing from text file

    Thanks! I'll give that a try.

    But what if you wanted to allow NULLS? Does SSIS have issues importing NULL values? Anybody else have any thoughts on this? Thanks guys!

  • RE: Connect to SAS Datasource

    I tried the .Net ODBC Data Provider to connect to the ODBC Source. Then I tried to use the DataReader Source connection. It seems like it picks up the columns...

  • RE: Poor Web App Performance?

    This is a vendor app, and I don't know much about connection pooling, but here's what I found. Anything jump out at you? Thanks for the help.

    <Config CacheSize="100" numSQLRetry="5" SQLRetryInterval="5000">

      <DBConnections ActiveConnection="xxxxxx" ...

  • RE: Cube summing/aggregating values incorrectly???

    cliff, think I got it. Found some NULLS in the date column in the fact table. Looks like the culprit. I'll use the COELESCE Function to handle them. Always good...

  • RE: Cube summing/aggregating values incorrectly???

    cliff, i'm sorry, that was incorrect. I was using the wrong test table. The INNER JOIN I listed above did produce the correct results for each line of business...man this is weird...

Viewing 15 posts - 16 through 30 (of 87 total)