"I was working on cleaning up some old code from a system I inherited," writes Anthony Mattas, "the system is an old ASP.NET application that has been around for a while, but won’t be replaced because it generates the staff meeting template for our CEOs weekly leadership meeting."

"The app itself had a lot of redundancy since my company didn’t have a good version control solution or strategy at that time. There was duplicate stored procedures, tables, and pages in the application (this was the old developers' method of version control). Along the way I found this stored procedure:"

CREATE PROCEDURE [sp_getNothing] AS

   select '' as Nothing

END

"To make matters worse," Anthony added, "this specific stored procedure was used 13 times within the application. "

[Advertisement] BuildMaster allows you to create a self-service release management platform that allows different teams to manage their applications. Explore how!