376 reputation
28
bio website
location United Kingdom
age
visits member for 2 years, 5 months
seen 15 hours ago

Jun
11
awarded  Scholar
Jun
11
accepted Do decimal separators behave differently for Money and Decimal data types?
Jun
11
comment Do decimal separators behave differently for Money and Decimal data types?
Apologies, it does indeed. This is what I'm seeing SSMS but is the opposite way around to the original problem just to be confusing. But this still answers the question as asked here. Thanks.
Jun
10
comment Do decimal separators behave differently for Money and Decimal data types?
Thanks for the answer. This seems like it may be relevant but this is actually the opposite way around; I'm seeing decimal values being formatted inline with the regional settings (using comma) and money values being formatted with a period regardless...
Jun
9
awarded  Student
Jun
9
asked Do decimal separators behave differently for Money and Decimal data types?
Mar
28
awarded  Critic
Mar
26
answered Create Table Script in SQL Server 2008 R2?
Mar
15
awarded  Commentator
Mar
15
comment Update Statement takes forever to complete
The answers at the moment are shots on the dark. If you provide the create table script (including indexes etc) you'll get much better answers.
Jan
28
answered Pulling data from identical tables in different databases
Nov
30
comment Broken tempdb location and can't recover
+1 never had to do this but good to know
Sep
16
comment Backup SQL Server with a system backup
+1 for appropriate use of bold text!
Jul
8
answered Combine datetime + string to make a proper datetime
Jun
8
answered Why don't databases create their own indexes automatically?
May
31
comment Updating a table with millions of records, its been 4 days
I've done this sort of thing on HES data many times (I'm guessing you're using SUS/HES) and it shouldn't take that long regardless of indexing or the use of left(,3) to join. Your hardware is more than enough for this. @gbn's answer is great, but I can say from experience here that that isn't the cause in this particular instance. Are you sure that table2 actually does hold a single copy of the PbR reference data?
May
30
awarded  Yearling
May
24
comment When to split a large table
If insert performance is not the issue, then you need to define what you mean when you say: Will this improve performance... performance in what context? What kind of operations will you need to do?
May
21
awarded  Constituent
May
21
awarded  Caucus