• Repost - originally posted 1-06-2012

Poor object naming

The following is an example of a poorly named table from a major backup software vendor. This caused failures with the regular maintenance which was being run.

That table was called Media_Views.UpdateMaxCleaningCount.

Notice the period in the table name.

SQL Servers full object naming convention is servername.databasename.schemaname.objectname.

In this case the table actually had a period in the table name so it became a five part naming structure, which caused errors.

There are lots of resources for SQL Server naming conventions and best practices, most of them state not to have periods in object names.

Other poor object naming that we have come across include:

  • a table named ‘View’

  • a database named ‘Convert’

You should also avoid using reserved words when creating your database and objects within a database.

Recent Posts

See All

Migrating SSIS packages to AWS

We are currently migrating a large amount of SSIS packages (SQL Server 2008R2) to SQL Server 2016 at AWS. It has been a learning exercise to get these packages running. What we have learnt (so far) is