Tag Archives: T-SQL

T-SQL Context Switching

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 , | Leave a comment

Lengthen a Primary Key–#SQLNewBlogger

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

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

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