Tags » Constraints

NOCHECK - the uses and impact

Having been bitten by the delights of a Foreign Key(FK) with NOCHECK I thought it time to do a little digging.

I’ve always been aware of the perils of this option but have encountered a table with this feature and I was caught out by it. 791 more words

SQL

What would you do?

What would you do?

If you could do absolutely anything?

If you had all of the freedom in the world?

If failure wasn’t an option? … 78 more words

Life Lessons

I'm tired of constraints

If you’re like me, there will be a point in time when you feel like jumping, rebelling, shouting and getting mad at your status quo. You don’t like it; Neither do I. 105 more words

Changes

DEFAULT Constraint - Adding Column Defaulting in Sql Server Table

The DEFAULT constraint is used to insert a default value into a column.

The default value will be added to all new records, if no other value is specified. 57 more words

Sql Server

Post-it notes and 3D unicorns

‘Green Eggs and Ham’ by Dr Seuss was one of the first books I really fell in love with. I remember it was a Christmas present left at the foot of my bed….one that I was allowed to open as soon as I woke up…however early. 1,006 more words

Social Innovation

What types of requirements does IT Architect have to gather?

As stated in previous post, IT systems work mostly functionally correct, but suffer in quality. The IT architecture design starts obviously with requirements. If system architecture provides the required functional capabilities, it means that functional requirements were gathered, defined and analyzed correctly. 759 more words

Embracing Constraints

It feels to be that I have a very delicately balanced existence.  It doesn’t take much to throw everything out of whack.  A demand for extra time in one area of my life has repercussions everywhere else, leaving me scrambling to pick up the pieces.  206 more words