I was participating in an email interview about my SQL career and opinions and one of the questions was basically "What's the worst SQL thing you've inherited?"
I gave them this list:
o SQL
2008 R2, RTM
o Incorrect
Memory configuration
o Full
recovery model on data that only changes once a week at most
o ZERO
documentation
o New
data is imported to a new table and a UNION ALL is modified to add that table
o ZERO
documentation
o Stored
Procedures have no comments, poor formatting and developer names in the name of
the sproc
o Autogrow
is 1MB, data imports are hundreds of MB each
o Everyone
is sysadmin, probably including you…
o Change
control process is intentionally shortcut and ignored on this internal
production system
o Ownership
changed to me in December, then was yanked back 3 weeks later with developers
overwriting my fixes in prod.
Really....all that on one server!
Upgrade your fries broseph!!!
Kevin3NF
No comments:
Post a Comment