SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Common Mistakes

By Steve Jones,

This editorial was originally published on Mar 20, 2014. It is being re-published as Steve is out of town.

At times I am rather dismayed by the quality of code I see written today. I'm not sure it's worse than the poor code compiled early in my career, but there are so many more people writing code in our industry that it seems there is more and more poorly written code.

We suffer from the chef problem in techology. As more companies look to become software companies, they need to hire more software people. To meet the staffing demand, more and more marginally skilled people will be chosen, and software quality goes down.

Part of what we do here is to try and educate the SQL Server professionals on how to become better at their jobs. That's really the core mission that started SQLServerCentral and continues today thanks to the belief in that mission by Red Gate Software. As we look to do that, we want to bring to light the things that aren't good ideas and can cause problems.

What common mistakes do you see T-SQL developers making?

The question this week is based on a post by the talented Doug Lane, who wrote about the top three mistakes T-SQL developers make. Doug has a good list, and I'd urge you to read it, along with some sage advice from Brad McGeHee. However I'm sure many of you see different common issues in your own work.

What things need to be fixed later? What code regularly causes performance issues? The more specific problems that you can share, along with their solutions, the more you might help another developer build better code in the future.

Total article views: 504 | Views in the last 30 days: 1
Related Articles

Tuning People?

Database people are used to changing the hardware of the server on which a problem database resides...


Rogue Software Changes

Today Steve Jones wonders if software developers would make changes to software on their own, withou...


Good Practices for Software Development

We always want to follow the best, or at least good, practices for software development. However do ...


Software Estimates

It seems the software industry doesn't do a good job of planning and estimating software development...


The Combinations of Software

The weakest link in the chain of software is a problem.

friday poll