Forum Replies Created

Viewing 15 posts - 3,886 through 3,900 (of 6,041 total)

  • RE: Here are some SQL Server Interview Questions

    Alvin Ramard (5/15/2015)


    Eric M Russell (5/15/2015)


    Grant Fritchey (5/15/2015)


    Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL,...

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

  • RE: Here are some SQL Server Interview Questions

    Grant Fritchey (5/15/2015)


    Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL, DB2, Couchbase, DocumentDB, Hadoop, Redshift,...

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

  • RE: Sql server random slow query

    Consider replacing the "SELECT TOP 1500" with "SELECT TOP 0".

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

  • RE: Here are some SQL Server Interview Questions

    Luis Cazares (5/14/2015)


    You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives in the morning. How...

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

  • RE: Here are some SQL Server Interview Questions

    Define "working correctly".

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

  • RE: Update takes too long

    When using a local or development envisonment to troubleshoot a performance issue in production, I focus my efforts on reducing logical reads or maybe CPU.

    A small box with 2...

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

  • RE: Sql server random slow query

    mdsantos (5/13/2015)


    Hi to all,

    In my company we are dealing with a very strange problem in the last couple of week in a SQL 2012 server. And maybe you could give...

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

  • RE: Documenting with Tests

    Some unit tests are derived from high level assertions (ie: each active sales person should be assigned to at least one but no more than three sales regions), and these...

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

  • RE: Opening Up Data

    TrailRunner,

    You mentioned training for DB2, MySQL, MongoDB, AWS (EC2 + RDS), Netezza, Linux, and Attunity within the past year. Are all these platforms leveraged on the same project, or do...

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

  • RE: Opening Up Data

    Iwas Bornready (5/13/2015)


    TrailRunner (5/12/2015)


    I switched to the new job for more learning opportunities, so learning new / different things is very important to me. However, too much of a good...

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

  • RE: Urgent SQL Developer vs Enterprise edition 2012/2014

    Jeff Moden (5/13/2015)


    Eric M Russell (5/13/2015)


    In addition to the above, unserstand that multiple users may connect to Developer Edition, but licensing requires that each user must have a developer edition...

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

  • RE: sudden increase in Table size

    Use this to get more detail about the internal storage of your table (clustered index) and non-clustered indexes, which includes avgerage fragmentation percentage and average page density.

    select

    schema_name(o.schema_id)schema_name,

    ...

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

  • RE: Urgent SQL Developer vs Enterprise edition 2012/2014

    In addition to the above, unserstand that multiple users may connect to Developer Edition, but licensing requires that each user must have a developer edition license, which is about $50...

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

  • RE: Update takes too long

    Jeff Moden (5/12/2015)


    I love it. A newbie to the forum with just 7 points and already posting million row test tables.

    Welcome aboard, Jason!

    We really should setup a file share...

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

  • RE: Opening Up Data

    TrailRunner (5/12/2015)


    I switched to the new job for more learning opportunities, so learning new / different things is very important to me. However, too much of a good thing is...

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

Viewing 15 posts - 3,886 through 3,900 (of 6,041 total)