282 reputation
215
bio website blog.codingbadger.com
location London, United Kingdom
age 31
visits member for 1 year, 6 months
seen Apr 3 at 11:51

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
Oct
19
comment Advice on how to approach data cleaning & importing
Sure, I will post it as an answer. It uses slightly different logic from your case example but your answer certainly fueled my initial thoughts :)
Oct
19
awarded  Scholar