Forum Replies Created

Viewing 15 posts - 6,661 through 6,675 (of 9,707 total)

  • RE: Delete rows older than 1 year (365 days)

    Jpotucek (1/26/2011)


    the table structure is listed above and there are no indexes on this small table

    Another thing I should point out. Look back at your table structure. See this line:

    PRIMARY...

  • RE: Delete rows older than 1 year (365 days)

    Jpotucek (1/26/2011)


    the table structure is listed above and there are no indexes on this small table

    How many rows in the table? Can you upload some sample data (make sure to...

  • RE: Delete rows older than 1 year (365 days)

    Look at the table size (width and length), see if the table has indexes (too few or too many?), look at the Dev's query, check Profiler and PerfMon for any...

  • RE: Delete rows older than 1 year (365 days)

    You really need to look up GetDate() in Books Online before you use it. Changing Date() to GetDate() will make SQL do what you tell it, but it may end...

  • RE: Today's Random Word!

    sleep

  • RE: Are the posted questions getting worse?

    Gus, where and how did you learn all this stuff? It's really fascinating.

  • RE: Are the posted questions getting worse?

    You could always give her the estimate for how long it will take just to map the processes and say you'll get back with the project timeline when that part...

  • RE: Are the posted questions getting worse?

    GSquared (1/25/2011)


    Sure.

    You want chicken or beef?

    Darnit. This answer is so much better than mine.

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/25/2011)


    Brandie Tarvin (1/25/2011)


    Lynn Pettis (1/25/2011)


    Grant Fritchey (1/25/2011)


    Thanks everybody.

    And remember, buy Red Gate... kidding, just kidding. Put that rock down.

    Stock or Products? 😉

    Stock, of course....

  • RE: Date table not in cube

    It seemed to be at first glance, until I realized I forgot to add dimension attributes to the new dimensions in my new cube build. So I'm starting once again...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/25/2011)


    Grant Fritchey (1/25/2011)


    Thanks everybody.

    And remember, buy Red Gate... kidding, just kidding. Put that rock down.

    Stock or Products? 😉

    Stock, of course. We know the people who are working...

  • RE: Date table not in cube

    Homer Simpson "DOH!" moment.

    I created DimDate as a normal dimension, not a Time Dimension. No wonder I couldn't get it to pull into the cube properly.

    Well, I won't make THAT...

  • RE: Abstract: Some Thoughts On Managing Teams

    The title sounds like it's only for team leads and managers. The abstract sounds like it's for everyone. It might help to make either the abstract more leadership oriented or...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/24/2011)


    Luke L (1/24/2011)


    I've gotta agree here(my emphasis above). What business case does your SQL servers tweeting supply that don't get with SMS Text, emails...

  • RE: Date table not in cube

    stevefromOZ (1/24/2011)


    Hey Brandie, when you say that BIDS won't let you, does it return any sort of error message or warning with this?

    No, actually. That's what has me so frustrated....

Viewing 15 posts - 6,661 through 6,675 (of 9,707 total)