Tag Archives: T-SQL

T-SQL Context Switching

Posted on October 7, 2019 by

Studies have shown that reading someone else’s code can be both stressful and time consuming. Developers that pick up unfamiliar code find themselves spending much more time comprehending the code than with more familiar projects. I think this might be … Continue reading →

Posted in Editorial | Tagged ,

Lengthen a Primary Key–#SQLNewBlogger

Posted on April 17, 2019 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a post recently where someone needed to increase the size of a PK and was getting a … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Upper Casing All the Data–#SQLNewBlogger

Posted on March 4, 2019 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. There was a post recently where a user asked about needing to update all the data in all their … Continue reading →

Posted in Blog | Tagged , | 2 Comments

Versions of Stored Procedures

Posted on February 6, 2019 by

I never knew this, but stored procedures have versions. I was browsing the CREATE PROCEDURE doc page, and stumbled upon this item. In the beginning part of a stored procedure definition, after the name, there is a section that starts … Continue reading →

Posted in Blog | Tagged , | 4 Comments