Reputation
310
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 12
Newest
 Constituent
Impact
~6k people reached

  • 0 posts edited
  • 1 helpful flag
  • 27 votes cast
Aug
17
comment Difference between count(*) and count(1) in mysql?
Yes, is interesting to see how the different RDBMS handle an invalid expression.
Aug
17
answered Difference between count(*) and count(1) in mysql?
Aug
14
awarded  Citizen Patrol
Jul
31
awarded  Editor
Jul
31
revised Implications of using a Unique NonClustered Index with Covering Columns instead of a Primary Key
The index 'redundancy' was spotted after being inspired by Kimberley Tripp's blog article - referenced.
Jul
30
comment Implications of using a Unique NonClustered Index with Covering Columns instead of a Primary Key
Thanks - it turns out that the index stats showed that the PK was still heavily used for scans. It seems I was being overzealous - the readability / convention benefits of retaining the PK should outweigh any storage implications in the long run. The point about transactional replication clinches it though - we WILL need to replicate this database shortly.
Jul
30
awarded  Scholar
Jul
30
accepted Implications of using a Unique NonClustered Index with Covering Columns instead of a Primary Key
Jul
26
awarded  Nice Question
Jul
26
awarded  Supporter
Jul
26
comment Implications of using a Unique NonClustered Index with Covering Columns instead of a Primary Key
Thanks - do you have any reference links? w.r.t. slightly worse, are you referring solely to the lower index density in the covering index, or is there something else which would cause this?
Jul
26
awarded  Student
Jul
26
comment Implications of using a Unique NonClustered Index with Covering Columns instead of a Primary Key
@jn29098 - Updated. Confirmed that we do have a clustered index, on columns which are neither the PK nor the covering columns, so this doesn't seem relevant to this decision.
Jul
26
asked Implications of using a Unique NonClustered Index with Covering Columns instead of a Primary Key
Feb
1
comment Attaching MDF without LDF
Have a look at this post - it discusses how to rebuild the log in emergency mode, but as it requires a restart of SQL server isn't something to do on your Prod Server (Nb - Jose Basilio's answer, not the accepted one) stackoverflow.com/questions/773059/…
Jan
4
awarded  Teacher
Jan
4
awarded  Autobiographer
Jan
4
answered Database table and NULLs
Oct
10
answered Included Index Vs Filtered Index