Reputation
2,120
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
8 15
Newest
 Caucus
Impact
~95k people reached

Apr
16
suggested approved edit on Using an RDBMS for querying tens of Terabytes of time-series data?
Mar
31
awarded  Yearling
Mar
9
awarded  Necromancer
Feb
20
comment Would it be considered as a bad practice to have multiple nullable FKs on a table in SQL Server
One nullable foreign key is one too many.
Feb
20
answered Would it be considered as a bad practice to have multiple nullable FKs on a table in SQL Server
Feb
17
awarded  Tag Editor
Feb
6
answered What computations can NOT be performed in standard SQL?
Jan
25
comment Shrinking log file
If your log files are growing regularly then shrinking like that is a massively counter-productive thing to do. Don't do it. By doing this you are invalidating the log backup sequence. My guess is you are using FULL recovery when you might be better off using SIMPLE.
Jan
25
comment Is an anomaly free relation necessarily normalized?
If "all normal forms" includes DKNF then the answer is no. A relation in 6NF does not have undesirable update, insertion or deletion anomalies in the usual sense but it still may not satisfy DKNF. On the other hand DKNF is not very important and is frequently irrelevant or unachievable.
Jan
20
awarded  Nice Answer
Jan
11
answered why doesn't time for a simple update scale linearly with the number of records?
Jan
9
comment SQL Server : primary keys advice to my whitepaper needed
It is premature optimization to allow the choice of clustered index to dictate the primary key of your tables. Very premature and very unnecessary!
Jan
9
comment SQL Server : primary keys advice to my whitepaper needed
All of your points are wrong because they apparently refer to the properties of clustered indexes and not primary keys. Clustered indexes and primary keys are two different things.
Jan
9
awarded  Cleanup
Jan
9
revised What Is The Point of a Primary Key?
"unique key" is a pointless tautology - keys are unique by definition. To be absolutely clear I have substituted "candidate key" instead.
Jan
9
revised What Is The Point of a Primary Key?
rolled back to a previous revision
Jan
6
awarded  Enlightened
Jan
6
awarded  Nice Answer
Dec
24
comment Temporarily disable checking of constraints
Oleg, I think it's not clear why you are suggesting "WITH NOCHECK CHECK" instead of "WITH CHECK CHECK". The latter should generally be used unless you intend to do it anyway later on.
Dec
17
answered Is normalization process needed?