Forum Replies Created

Viewing 15 posts - 10,441 through 10,455 (of 11,676 total)

  • RE: Date dimension doesnt give proper result

    I don't think your hierarchy is built correctly.

    It should be year -> month -> date.

    January 17, 2011 at 1:56 am

    #1274134

  • RE: Are the posted questions getting worse?

    Henrico Bekker (1/17/2011)

    What is up with all the spam threads?

    Indeed. Very annoying. And dissapointing as well, since I thought I could win a fun award. :angry:

    January 17, 2011 at 1:48 am

    #1274130

  • RE: generating or populating time dimensions

    gupta.sreekanth (1/12/2011)

    i,can any one help me in populating time dimensions in sql from 2000 to 2030 for every 15 min.now i need to create time dimensions from 2000 jan 01...

    January 17, 2011 at 1:46 am

    #1274129

  • RE: transaction log

    kln2020 (1/17/2011)

    ok, how can I know the defult time that sql define for checkpoint ?

    I ask you this because when I run some Insert query into table, I sea the...

    January 17, 2011 at 1:41 am

    #1274125

  • RE: How to create SSIS package using java

    gvrsony (1/16/2011)

    I want to transfer data from any database table to MS SQL server, so that we can do the same job again and again for day today job. I...

    January 17, 2011 at 1:35 am

    #1274123

  • RE: The Spring Semester

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

    Comments posted to this topic are about the item <A HREF="/articles/Editorial/72161/">The Spring Semester</A>

    This is indeed a great project I wasn't aware of. Thanks for highlighting...

    January 17, 2011 at 12:06 am

    #1274100

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/16/2011)

    And then there are those responses that are simply confusing. Truely some people have the gift of confusion. (No, I am not providing a link to...

    January 17, 2011 at 12:03 am

    #1274098

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/16/2011)

    GilaMonster (1/16/2011)

    ...

    Gail, just read this thread. Interesting how the OP couldn't deduce what you were saying from your original answer. I guess the real problem we...

    January 17, 2011 at 12:02 am

    #1274097

  • RE: Event Handlers Not working

    me_always (1/16/2011)

    Got the answer..

    I was executing my data flow task by right clicking..

    When I run the entire package, event handler works..

    Thanks everyone for help.

    Glad that you found the solution!

    But for...

    January 16, 2011 at 11:54 pm

    #1274095

  • RE: How i can convert data type

    What do you mean with no luck when using the data conversion component?

    Where there any errors? if yes, please post them here.

    Try changing the data type in the advanced editor...

    January 16, 2011 at 2:45 am

    #1273966

  • RE: Restore

    Great question.

    I had to do some research to rule out extent, so I definately learned something.

    January 16, 2011 at 2:41 am

    #1273965

  • RE: New SSMS addin, complete with demo videos, but need advice

    allmhuran (1/15/2011)

    All in all I've learned a heck of a lot on this project so far.

    That's the most important thing.

    Good luck!

    And if the website is up, let us know...

    January 16, 2011 at 2:17 am

    #1273964

  • RE: There is insufficient system memory in resource pool 'internal' to run this query.

    Dinculescu Mihai (1/15/2011)

    Looks like adding some GOs between the inserts solves this issue. Makes sense, I'm ashamed I didn't figure this out faster.

    I'm glad you found the solution! (rather easy...

    January 15, 2011 at 9:46 am

    #1273920

  • RE: Derived Column Question

    Phil Parkin (1/15/2011)

    An alternative is to create a mapping table in SQL Server and use a LOOKUP to get the result you need. Much easier to maintain and handles easily...

    January 15, 2011 at 9:44 am

    #1273919

  • RE: New SSMS addin, complete with demo videos, but need advice

    allmhuran (1/15/2011)

    Thanks for your feedback. Yep, this is exactly the kind of stuff I'm thinking about.

    We are actually using the addin at my place of work with great success. I'm...

    January 15, 2011 at 6:20 am

    #1273896

Viewing 15 posts - 10,441 through 10,455 (of 11,676 total)