Forum Replies Created

Viewing 15 posts - 4,546 through 4,560 (of 6,041 total)

  • RE: many to many relationship

    aajavaherian (5/5/2014)


    Hi, why do we need a junction table in a many to many relationship? Why can't everything be in just 2 tables?

    So we know what you're suggesting, show...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Hash Match

    Jeff Moden (5/5/2014)


    Steve Jones - SSC Editor (5/5/2014)


    Jeff Moden (5/3/2014)


    I think a much better question would be, "What determines what will be the first (top) table (according to books online)...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Better, Faster, and Cheaper

    Robert.Sterbal (5/5/2014)


    Eric M Russell (5/5/2014)


    I'd say that Chipotle Mexican Grill is good, fast, and cheap. However, as with any application, whether it be software or a restraunt, how the end...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Changed behavior or am I missing something?

    What method did you use to port the database?

    Remember to use a schema comparison tool to insure things like indexes, table options, statistics, constraints, plan guides, etc. are all the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Better, Faster, and Cheaper

    I'd say that Chipotle Mexican Grill is good, fast, and cheap. However, as with any application, whether it be software or a restraunt, how the end user perceives "good" is...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Outer Join performance

    So, [widgets] looks like an EAV (entity attribute value) table. This is similar to the common scenario where users request a query containing CustomerID, HomePhone, CellPhone, WorkPhone and all phone...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: User with Sysadmin rights fails login attempt (SSIS)

    Yes, I've seen that one before, SSIS simply chooses to ignore a dtsConfig file containing a malformed tag. There was no error regarding the config file, it just reverted back...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: User with Sysadmin rights fails login attempt (SSIS)

    Brandie Tarvin (5/2/2014)


    I remoted into the app server (not web server, I keep saying that wrong) with the login in question. I logged into SSMS using windows authentication and opened...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The new 3D Joins in SQL Server 2014

    Eirikur Eiriksson (4/1/2014)


    Has anyone tried out the new 3D joins in 2014?

    I can confirm that 3 dimensional joins work quite well; it's the 12 or 20 dimensional joins that are...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Hash Match

    Given the options: first, larger, smaller, or second input, I still say that 'smaller input' is closest to the correct answer.

    On his MSDN blog, Craig Freedman goes into...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Database monitoring

    The DMV sys.dm_exec_query_stats accumulates performance statistics about cached query plans, which is perfect for keeping track of the expense of queries. That's easy, but now if only there were an...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Subtle Push to the Cloud

    GoofyGuy (4/29/2014)


    Ed Pollack wrote:

    ... if your product has an uptime requirement of 99.95, then Azure is immediately out-of-the-question as it promises only 99.9%.

    The difference in uptime, over the course of...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Subtle Push to the Cloud

    Peter E. Kierstead (4/29/2014)


    Subtle push? More like an overt attempt to sell an ostensibly benefit for even more access and control over private data by not-always-visible entities (read what security...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Subtle Push to the Cloud

    djackson 22568 (4/29/2014)


    Eric M Russell (4/29/2014)


    Gary Varga (4/29/2014)


    I guess the current threat on Net Neutrality plays into this discussion too.

    Net Neutrality is a double edged sword; sure your Netflix movies...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Subtle Push to the Cloud

    Gary Varga (4/29/2014)


    I guess the current threat on Net Neutrality plays into this discussion too.

    Net Neutrality is a double edged sword; sure your Netflix movies will stream more smoothly at...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 4,546 through 4,560 (of 6,041 total)