Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
4
Newest
 Teacher
Impact
~11k people reached

  • 0 posts edited
  • 0 helpful flags
  • 9 votes cast
Oct
10
awarded  Teacher
Oct
9
answered How do I identify the column(s) responsible for “String or binary data would be truncated.”
Nov
28
comment Does it make sense to use full recovery if the data and log files are on the same HD?
you added a very good point, I just had a meeting with management and explained what were the options and we will budget for an extra drive for the SQL server to separate data and logs and also set up frequent transaction log backups so the logs don't grow indefinitely. Thank you all for the comprehensive answers!
Nov
28
accepted Does it make sense to use full recovery if the data and log files are on the same HD?
Nov
27
awarded  Student
Nov
27
comment Does it make sense to use full recovery if the data and log files are on the same HD?
this is interesting, it seems that devs messing with production dbs is a more common problem than I thought! (knocks on wood 3 times)
Nov
27
awarded  Scholar
Nov
27
awarded  Supporter
Nov
27
asked Does it make sense to use full recovery if the data and log files are on the same HD?