meta user
network profile
| bio | website | |
|---|---|---|
| location | Sydney, Australia | |
| age | ||
| visits | member for | 9 months |
| seen | yesterday | |
| stats | profile views | 43 |
|
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 |
