Forum Replies Created

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

  • 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...

  • RE: Complex View Inserts

    This highlights the issues of confusing views with tables and views referencing other views. In my 30+ years, I've found that such practices lead to more problems than solutions.

  • RE: How Far Have You Traveled for a SQL Saturday?

    Steve Jones - SSC Editor (7/29/2016)


    Ha, we have a living quarters as well. Maybe we can roll together to an event? Or you can swing by the ranch when you...

  • RE: How Far Have You Traveled for a SQL Saturday?

    First off Steve, I completely agree with you about the new ruling for the 600 mile radius. Having SQL Saturdays in close proximity back-to-back allows many to attend who...

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