1,064 reputation
31335
bio website
location Sydney, Australia
age
visits member for 2 years
seen Aug 28 at 4:32

Oct
30
accepted Calling a .NET method in a SQL Server script
Oct
30
comment Calling a .NET method in a SQL Server script
As I had mentioned above the CSharp code provides a method that gets a string, manipulates it based on a complex logic and returns the converted string. This new string will be loaded in the target table. So I get a string (column value) from a source table, run the CSharp method (somehow) and writes the converted value to the target table. The number of source records are to be converted and loaded would be around 20,000.
Oct
30
comment Execute job every time database changes - execute job on each change-event
Could you explain more about the "every time database changes"? Are you referring to data changes in the source tables?
Oct
30
asked Calling a .NET method in a SQL Server script
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