Forum Replies Created

Viewing 15 posts - 6,976 through 6,990 (of 11,678 total)

  • RE: Strange behaviour on Adventure Works DW

    Jonathan Kehayias (6/4/2012)

    Koen Verbeeck (6/4/2012)

    The hardware is just a standard Dell laptop, with 8Gb RAM and i7 Intel processor.

    I'm at work now, so I'll post the details later.

    I created the...

    June 5, 2012 at 11:36 am

    #1497225

  • RE: The Beer Cooler Thread

    Jeff Moden (6/4/2012)

    Looks like a Budweiser in a really cool glass. You didn't spit it out did you? 😛

    I didn't 🙂

    June 5, 2012 at 11:03 am

    #1497197

  • RE: SSIS 2012 - Versioning

    L' Eomot Inversé (6/5/2012)

    Koen Verbeeck (6/4/2012)

    The major/minor version are properties from Visual Studio if I'm not mistaken.

    So it's not the SSISDB that performs the versioning, but you yourself in Visual...

    June 5, 2012 at 6:49 am

    #1497014

  • RE: SQL 2012 BOL

    The answer is pretty easy to find, so I think most people just guessed (wrong).

    June 5, 2012 at 4:55 am

    #1496968

  • RE: Strange behaviour on Adventure Works DW

    Allright, thanks for the information.

    June 4, 2012 at 11:55 pm

    #1496908

  • RE: Transaction across multiple databases in SSIS

    Tarun Jaggi (6/4/2012)

    I have multiple Execute SQL Tasks (running on different databases) and Data Flows

    You'll need to use the SSIS transactions.

    Is MSDTC running on every node and is it properly...

    June 4, 2012 at 11:48 pm

    #1496906

  • RE: Strange behaviour on Adventure Works DW

    Jonathan Kehayias (6/4/2012)

    Koen Verbeeck (6/4/2012)

    The hardware is just a standard Dell laptop, with 8Gb RAM and i7 Intel processor.

    I'm at work now, so I'll post the details later.

    I created the...

    June 4, 2012 at 11:40 pm

    #1496902

  • RE: Transaction across multiple databases in SSIS

    Tarun Jaggi (6/4/2012)

    Can I use BEGIN DISTRIBUTED TRAN inside "Execute SQL Task"?

    If you're working with linked servers and every TSQL statement is in one Execute SQL Task, then yes, you...

    June 4, 2012 at 11:34 pm

    #1496900

  • RE: SQL 2012 BOL

    Nice one, thanks.

    Easy to answer actually, as the first answer never could be the correct one (2 and 3 contradict each other), so you only had to figure out which...

    June 4, 2012 at 11:31 pm

    #1496898

  • RE: SSIS 2012 - Versioning

    L' Eomot Inversé (6/4/2012)

    The catalog.packages view holds version_minor, version_major, and version_build for each package, which seems to make packages pretty well versioned. It also holds version_comments with comments for...

    June 4, 2012 at 11:16 pm

    #1496895

  • RE: Strange behaviour on Adventure Works DW

    The hardware is just a standard Dell laptop, with 8Gb RAM and i7 Intel processor.

    I'm at work now, so I'll post the details later.

    I created the columnstore index and now...

    June 4, 2012 at 11:11 pm

    #1496893

  • RE: Developing SSIS Packages for Remote SQL Server

    dwain.c (6/4/2012)

    I appreciate all the responses to my question, especially the Attunity connector which I will need to investigate.

    Attunity is the way to go. It is as far as I...

    June 4, 2012 at 11:08 pm

    #1496892

  • RE: Strange behaviour on Adventure Works DW

    Allright, I reran the scripts and the results are in attachment.

    The results are quite inconsistent. The first time creating the index took me about half an hour, the second time...

    June 4, 2012 at 3:25 pm

    #1496799

  • RE: Strange behaviour on Adventure Works DW

    Robert Davis (6/4/2012)

    I didn't experience any problems with the queries either. I ran it on my laptop with 8 CPU and 16 GB of RAM (which was running 3 other...

    June 4, 2012 at 2:33 pm

    #1496769

  • RE: Are the posted questions getting worse?

    Jack Corbett (6/4/2012)

    Brandie Tarvin (6/4/2012)

    Gianluca Sartori (6/4/2012)

    mtillman-921105 (6/1/2012)

    So I suppose a lot of people rent in Europe?

    70% of Italians own the house they live in.

    Well, sort of.

    Who owns...

    June 4, 2012 at 2:26 pm

    #1496764

Viewing 15 posts - 6,976 through 6,990 (of 11,678 total)