Tag Info

Hot answers tagged

2

I echo the "bad form" comment of @JohnM - design the thing properly, and if you have new requirements (or your design isn't perfect first time - unlikely I know :-) ), then choose to add new fields. Use JSON if it suits your clearly demonstrated requirements, otherwise stick with "normal" field types. I've seen too many systems where these "spare fields" ...


2

If you're running Enterprise edition, you can add and remove indices, including clustered indices, with ONLINE. Since your existing PK isn't being used, you can start by dropping it. Then create your new clustered index, and finally drop your old non-clustered index which is now obsolete. ALTER TABLE MyTable DROP CONSTRAINT PK_MyTbl_SrgKey WITH ...


1

No. The reason why database designers are interested in FDs is because they are a formalisation of Business Rules - rules about the data which accurately reflect the Business Domain to be modelled in the database. The only sound and practical way to identify FDs is by analysing and understanding a set of business requirements. Suppose you are designing a ...



Only top voted, non community-wiki answers of a minimum length are eligible