Reputation
227
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 6
Newest
 Yearling
Impact
~18k people reached

Mar
19
revised Building a where clause based on user selections
Fix phrasing and spelling
Mar
19
answered Is it possible to allow missing value inserts in mysql instead of requiring “NULL” in the query?
Mar
19
suggested approved edit on Building a where clause based on user selections
Mar
18
comment Denormalized table designs in normalized database?
Also, when devs start mentioning things like "MongoDB", "Big Data" and the likes... they're looking to pad their resume unless: 1) you're talking about multi-TB amounts AND 2) the data is disparate, meaning there are things in there you cannot parse, like PDF blobs. If #1 is not applicable, it's Messy Data; if #1 is satisfied but #2 is not, it's Lots Of Data.
Mar
18
comment Denormalized table designs in normalized database?
The real issue is not storage, it's that you can't really DO anything with that data. It's a damned flat file dumped into an RDBMS. Any interesting questions (unique number of X, for example) will have to be answered over and over and over again in sub-queries... hence the @JNK recommendation to yes, dump it like that, THEN clean it up into something you can get useful information out of.
Mar
18
answered Should I Denormalize Tables To Avoid Joins?
Nov
1
awarded  Yearling
Oct
4
awarded  Excavator
Mar
14
answered What alternatives exist when a table requires too many foreign keys?
Mar
14
revised Index use and column type
bunch of code tags
Mar
14
suggested approved edit on Index use and column type
Mar
14
comment Index use and column type
To put it more bluntly: specifying a width for int at a database level is asinine and asking for trouble.
Mar
7
comment How can I calculate time spent at work in a single column?
UserID, SignIn, SignOut
Mar
7
comment How can I calculate time spent at work in a single column?
These answers do not correspond to the data in the question, correct?
Feb
27
revised Pull Access schema into a SQL Server table
typos, caps. etc
Feb
27
comment managing a growing database in the long run (10 years from now)
In a few years MySQL will have changed, your web host will have different pricing, HDD prices will have changed and CPUs will have changed. It is impossible to predict what will be best at that point.
Feb
27
suggested approved edit on Pull Access schema into a SQL Server table
Feb
27
comment How might a corrupt partition in TempDB result in DBCC CHECKDB reporting no issue?
There's also this, but you'd think it would have been fixed by 2012: sqlservercentral.com/Forums/Topic770808-149-1.aspx
Feb
27
comment How might a corrupt partition in TempDB result in DBCC CHECKDB reporting no issue?
Are you sure the service was not restarted in the meantime?
Feb
26
awarded  Editor