2,522 reputation
328
bio website
location
age
visits member for 1 year, 6 months
seen Jan 17 at 3:56

Apr
3
awarded  Announcer
Feb
28
awarded  Notable Question
Jan
7
awarded  Popular Question
Jan
7
awarded  Popular Question
Dec
5
awarded  Popular Question
Nov
15
awarded  Popular Question
Oct
21
accepted Why won't SQL Server optimize the UNIONs?
Oct
15
awarded  Popular Question
Oct
10
awarded  Popular Question
Oct
2
awarded  Yearling
May
23
awarded  Popular Question
May
21
awarded  Constituent
May
13
awarded  Caucus
May
2
comment SELECT COL_NAME(969262708, ORDINAL_POSITION) returns a NULL value in one of the rows
@mattedgod SQLFiddle won't show anything here. It's data related.
May
1
answered Challenge. Split database 500 records in two smaller datasets, randomly
May
1
comment Restoring SQL Server 2012 database onto 2008
You can use SSIS to pump data between the two servers, assuming they can see each other
Apr
26
comment Extract part of string based on nth instance of character
There's something wrong (minor) with the answer - running it verbatim returns Wednesday etc for s.rn=6, not ServerA etc as the result shows.
Apr
26
revised Extract part of string based on nth instance of character
added 681 characters in body
Apr
26
answered Extract part of string based on nth instance of character
Apr
25
comment Is this table in 3NF?
@Mike Perhaps in the purest sense with just these 5 fields you may be right. I had half-assumed there were other attributes or perhaps in future more would be added to each distinct entity. City would have its own GPS location and mayor_id, State would have boundary (geo-polygon) etc. The transitive dependency then becomes clearer -> person (id) is related to country only by way of state and state through city. Transitive dependencies lead to redundant data hence the point of normalisation. If person is tie-broken using id, why doesn't it also apply to city_id?