Viewing 15 posts - 196 through 210 (of 401 total)
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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
December 5, 2016 at 9:31 am
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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
December 5, 2016 at 9:17 am
Carlo Romagnano (9/22/2016)
Aaron N. Cutshall (9/22/2016)
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
September 22, 2016 at 7:59 am
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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
September 22, 2016 at 6:56 am
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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
September 16, 2016 at 6:18 am
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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
September 1, 2016 at 11:35 am
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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
September 1, 2016 at 6:36 am
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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 30, 2016 at 7:06 am
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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 30, 2016 at 6:47 am
Have a safe, enjoyable trip Steve and I hope to run into you at Summit! 😎
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 26, 2016 at 6:41 am
RonKyle (8/11/2016)
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 11, 2016 at 7:33 am
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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 11, 2016 at 7:02 am
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.
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
August 1, 2016 at 5:59 am
Steve Jones - SSC Editor (7/29/2016)
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
July 29, 2016 at 10:45 am
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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
July 29, 2016 at 6:26 am
Viewing 15 posts - 196 through 210 (of 401 total)