1,044 reputation
21035
bio website
location Sydney, Australia
age
visits member for 1 year, 11 months
seen Jul 16 at 2:11

Oct
23
revised Data dictionary best practices in SQL Server 2008 r2
deleted 1 characters in body
Oct
23
comment Partitioning in SQL Server 2008
Adam, it is a good idea, but for my own benefit, what's gonna happen if the archived data, say a record in data_Feb12 needs to be updated? I think if there is likelihood of having changes on historical data, a process should be in place to facilitate it.
Oct
23
revised Data dictionary best practices in SQL Server 2008 r2
added 12 characters in body
Oct
23
asked Data dictionary best practices in SQL Server 2008 r2
Oct
22
awarded  Peer Pressure
Oct
20
answered How to represent aggregates in a data warehouse
Oct
19
asked Issues on defining a PK on a nvarchar column and indexing the FK referring this PK
Oct
15
revised Database design: where do I put this data?
added 781 characters in body
Oct
15
comment Database design: where do I put this data?
Not exactly. Please refer to my edited answer below.
Oct
14
comment Database design: where do I put this data?
Ian, this is the fact based on your scenario. If you aren't happy with it, there is another option: Adding a table which contains the shared columns. This table will sit between the 'Event' and 'Category Event' table. In this table you will have only shared columns.
Oct
14
comment Database design: where do I put this data?
Adding a new table which determines the type,tells you what the type of the Event is, but it does not accommodate the extra columns that are only applicable to one specific Event. Where are the 'Extra Fields' referred in the question stored now?
Oct
14
accepted Tablix cells width issue in SSRS
Oct
14
answered Tablix cells width issue in SSRS
Oct
14
answered Database design: where do I put this data?
Oct
14
asked System test Database user management
Oct
12
accepted The best way to rename the tables after development completed
Oct
12
comment The best way to rename the tables after development completed
We are now at the development phase, but system has almost been completed for that component which these tables are to be renamed. System is now deployed to UAT.
Oct
12
comment The best way to rename the tables after development completed
Thanks for your good answer, but would you be able to advise me what you mean by : "This way you can change the app(s) one at a time (or even one reference at a time), without having to change all of them at once. ". Do you mean we should create the synonym one at the time for example first table t1, do the code changes, then table t2, etc?
Oct
11
asked The best way to rename the tables after development completed
Oct
9
answered SQL Server virtual log size