1,099 reputation
31740
bio website
location Sydney, Australia
age
visits member for 2 years, 3 months
seen Nov 12 at 22:47

Nov
22
asked Microsoft Visual Studio is Busy
Nov
22
asked Simulating having multiple Control Flows in a SSIS package
Nov
4
revised How to Handle Database for Application which Starts from Scratch Annually
edited body
Nov
4
revised How to Handle Database for Application which Starts from Scratch Annually
deleted 16 characters in body; added 5 characters in body
Nov
4
answered How to Handle Database for Application which Starts from Scratch Annually
Nov
3
answered Storing date increments in tables
Nov
2
accepted How to grant a user UNSAFE ASSEMBLY permission
Nov
2
asked How to grant a user UNSAFE ASSEMBLY permission
Nov
1
accepted SQL Server database generate script how to avoid adding PRINT statements
Oct
31
asked SQL Server database generate script how to avoid adding PRINT statements
Oct
31
answered Installing 32bit SSRS on 64bit Windows/IIS
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