312 reputation
216
bio website blog.codingbadger.com
location London, United Kingdom
age 31
visits member for 2 years, 1 month
seen yesterday

Feb
15
accepted What to do with duplicate lookup information
Feb
15
comment What to do with duplicate lookup information
Thanks! That was my other idea but it seemed a bit like I was dropping bits of information I may need (The original Id's of the customer state in their respective systems) However, thinking about it I am not sure what I would use them for. Getting caught up in over thinking I suspect!
Feb
15
asked What to do with duplicate lookup information
Feb
12
comment Database not naturally shrinking log file
Damn it - cannot believe I couldn't find that!
Feb
12
asked Database not naturally shrinking log file
Feb
4
awarded  Informed
Jan
10
answered Remote Desktop Session's Machine ID for SQL Server Query
Jan
8
revised How do I use SSMS to compare Database 1 Table 1 against Database 2 Table 1?
formating and typos
Jan
8
suggested suggested edit on How do I use SSMS to compare Database 1 Table 1 against Database 2 Table 1?
Jan
2
awarded  Quorum
Nov
23
answered Special Oracle Order
Nov
5
awarded  Benefactor
Nov
5
accepted Powershell script executing within SQL Server Agent
Nov
1
awarded  Promoter
Oct
29
comment Powershell script executing within SQL Server Agent
@PatrickKeisler No I haven't - how would I do that?
Oct
26
comment Powershell script executing within SQL Server Agent
@PatrickKeisler Yes it is.
Oct
25
asked Powershell script executing within SQL Server Agent
Oct
19
comment Advice on how to approach data cleaning & importing
@Jon Ah yes, you are totally right there. I am not sure how I didn't notice that. I may have used the SourceTable at some point and forgotten to remove it. Still tinkering and monitoring at the moment so I may well change the approach. I am processing ~100 event types which is taking ~2minutes which is well within my time constraints. Thanks for your input :-)
Oct
19
comment Advice on how to approach data cleaning & importing
Answer posted! :)
Oct
19
answered Advice on how to approach data cleaning & importing