Thank this author by sharing:
By Andy Warren,
It's funny how the smallest things can trip you up. Stop and think for a
minute - if one of your developers requests a column be added to a table, how
much effort do you (or should you) expend to make sure it won't break anything?
Some things you might consider:
Are there other things you check? Or that have tripped you up?
Identity column value should not be increased if there's pbm in insertion of record.
Earlier in the month I shared with you 10 Things That Every DBA Should Do and so it only seems natur...
Presentation Files: 10 Things All BI Administrators Should Know
I sooooo remember this sign!
Validating all the columns in a record
distinct records based on one column, but records need all columns
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.