Monthly Archives: August 2012

On theory and practice

A conversation with a data modeler and a comment left on another blog led to this week’s commentary. The former revolved around how a PK should be defined on a child table. The data model called for Parent_ID to be … Continue reading

Posted in SQL Server Development | Tagged | Leave a comment

When standards become straitjackets

I am not a fan of the proliferation of coding standards. Don’t get me wrong: they have their uses. Database collation, ANSI settings, file locations, security practices: these are all sensible candidates for enterprise-level rules. But telling me that I … Continue reading

Posted in SQL Server Development | Tagged | Leave a comment

On getting better every day

I once had a conversation with a colleague regarding a script she had written for a one-time UPDATE and SELECT. I suggested some changes that I felt would improve the performance noticeably and save the DBA who would be running … Continue reading

Posted in SQL Server Development | Tagged | Leave a comment