Reputation
2,369
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
1 8 14
Newest
 Yearling
Impact
~155k people reached

Oct
21
awarded  Yearling
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.
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.
Oct
29
awarded  Good Answer
Oct
21
awarded  Yearling
Oct
18
comment Why is naming a table's Primary Key column “Id” considered bad practice?
@Thomas: then you need aliases in every query...