XML Feeds
This is a naming convention issue. Tables should not be prefaced with tbl because it does nothing to add to the clarity of the code (self-documenting). It actually has the opposite effect because it takes longer to read it and causes you to perform an interpretation of the three letter abbreviation.
How to detect this problem:
tsql
- SELECT *
- FROM Information_Schema.tables
- WHERE Table_Type = 'Base Table'
- And Table_Name Like 'tbl%'
How to correct it: Rename the table to remove the prefix. This is not as simple as it seems because this table could be referenced from a number of places, including views, stored procedures, user defined functions, index creation scripts, in-line SQL (embedded within front end applications), etc...
Level of severity: mild
Level of difficulty: moderate to high
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.