Forum Replies Created

Viewing 15 posts - 181 through 195 (of 389 total)

  • RE: Query Performance Tuning – A Methodical Approach

    GilaMonster - Friday, February 10, 2017 2:13 PM

    No. those two queries are completely identical in results and performance.

    If, however,...

  • RE: Query Performance Tuning – A Methodical Approach

    Since Steve was kind enough to re-post this in today's daily email, I just now was able to read this posting.  Nice job Gail!

    While the purpose of the...

  • RE: GetDate() in blocked sessions

    Blech! I knew the right answer but clicked the wrong option. Goes to prove that jumping too quickly to answer without double-checking can be hazardous!

  • RE: Import data in parquet format

    The team did identify a method of pushing the data to SQL Server but this approach requires coordinating the stored procedure execution on SQL Server to occur AFTER the data...

  • RE: Import data in parquet format

    That's the thing I like about you Jeff. You're always full of optimism and hope! 😛

    However, I've not given up hope yet. Who know, since support for XML...

  • RE: Complex foreign key

    Carlo Romagnano (9/22/2016)


    Aaron N. Cutshall (9/22/2016)


    I got the responses correct except that I also included "Command(s) completed successfully." -- which does flash briefly due to the master table creating successfully...

  • RE: Complex foreign key

    I got the responses correct except that I also included "Command(s) completed successfully." -- which does flash briefly due to the master table creating successfully (doing them individually shows that...

  • RE: VALUES limit

    BrainDonor (9/16/2016)


    They are defaults within Tools/Options/SQL Server Object Explorer/Commands (in SSMS 2014 - may be elsewhere in other versions) and therefore configurable.

    This affects the defaults within SSMS sessions for the...

  • RE: Avoiding Stored Procedures

    xsevensinzx (9/1/2016)


    At what point do you stop and launch? When is done, done?

    Don't get me wrong. I'm not saying that we need to spend lots of time in planning...

  • RE: Avoiding Stored Procedures

    chrisn-585491 (9/1/2016)


    Design choices that impact the database matter.

    I totally agree. As a data architect, I get frustrated when development managers are only concerned with right now and eschew data...

  • RE: Avoiding Stored Procedures

    Ralph Hightower (8/30/2016)


    Switching the patient lookup to a stored procedure increased the performance of that phase of the application by 25%.

    Ralph, it's all in how the stored procedure was written...

  • RE: Avoiding Stored Procedures

    One of the issues I've found with ORM frameworks is that it trains one into a particular way of thinking. For example, I worked on a project that was...

  • RE: Up, Up, and Away

    Have a safe, enjoyable trip Steve and I hope to run into you at Summit! 😎

  • RE: An object lesson about what is really important

    RonKyle (8/11/2016)


    I would tell my kids that "Family comes first, but not always." There would be times in life where work temporarily came first. Had it remained permanently...

  • RE: An object lesson about what is really important

    Good reminder Ben. I had to learn a long time ago that you work to live, not live to work. If your life is out of balance, so...

Viewing 15 posts - 181 through 195 (of 389 total)