2,361 reputation
1714
bio website
location Malta
age 45
visits member for 3 years, 9 months
seen May 2 at 14:15

aka Shawn

  • SQL Server Developer/DBA
  • MySQL Developer
  • British expat
  • Code monkey

Jul
16
awarded  Announcer
Oct
21
awarded  Yearling
Apr
22
answered SQL Server + database design and non mandatory fields
Mar
25
revised Should lookup tables enumerating strings have an integer primary key?
added 404 characters in body
Mar
25
comment Should lookup tables enumerating strings have an integer primary key?
@RumiP. updated my answer. Database size bloat is your problem
Mar
25
revised Should lookup tables enumerating strings have an integer primary key?
added 404 characters in body
Mar
25
comment Should lookup tables enumerating strings have an integer primary key?
@RumiP. use strings in the main table then. If your DB is small enough that storage and string processing is not a problem then you're OK. Don't try this on big databases though.
Mar
25
answered Should lookup tables enumerating strings have an integer primary key?
Feb
19
awarded  Caucus
Oct
21
awarded  Yearling
Apr
17
awarded  Good Answer
Feb
14
comment How to store record statuses (like pending, complete, draft, cancelled…)
Also see dba.stackexchange.com/q/11631/630
Feb
14
comment Should every member of a team use the same IDE?
@daramarak: Where does this cross into arrogance or being a prima donna, especially for larger shops with a corporate standard? Remember: new guys walking into a new company saying "we want this" is arrogance.
Jan
12
comment What are the chances of getting a good development job without the training in solving programming puzzles?
@RobertELee: ha ha ha. Now who's making assumptions. Deal with it: you asked a public question on a public forum.
Jan
12
revised What are the chances of getting a good development job without the training in solving programming puzzles?
added 789 characters in body
Jan
12
comment What are the chances of getting a good development job without the training in solving programming puzzles?
You asked "What are the chances that I will be given programming puzzles to solve?". I gave examples of where folk ask relevant ones. What do you think is relevant to ask then? API calls?
Jan
12
answered What are the chances of getting a good development job without the training in solving programming puzzles?
Dec
31
comment Why the Select is before the From in a SQL Query?
@S.Lott: Example, msdn.microsoft.com/en-us/library/ms189499.aspx
Dec
30
comment Why the Select is before the From in a SQL Query?
@Digger: LINQ follows the OO/modern Object.Method or Object.Property. Don't forget SQL has been around for 40 years
Dec
30
comment Why the Select is before the From in a SQL Query?
It's a DBA conspiracy to keep OO monkeys in their place.