Posts

All the articles I've posted.

• FluentMigrator timeout when adding a new column to a large table

  Published: 27 Aug, 2014 |  at  02:00 PM

  Discusses the challenges and solutions for adding a new column to a large table using FluentMigrator, including handling timeouts and adjusting SQL command timeout settings.

• P vs NP explained

  Published: 26 Aug, 2014 |  at  04:34 PM

  An overview of the P versus NP problem, explaining the difference between the complexity classes P and NP and the significance of determining whether every problem whose solution can be quickly verified can also be quickly solved.

• The story of AllowRowLocks equals false. When indexes go bad.

  Published: 25 Aug, 2014 |  at  12:55 PM

  Discusses the challenges and solutions related to SQL Server indexes with AllowRowLocks set to false, including troubleshooting deadlocks and failed deletes, and provides guidance on enabling row locks.

• Saving Table Space Quick And Dirty

  Published: 19 Aug, 2014 |  at  06:26 AM

  A practical guide on reducing database space usage with a SQL script that identifies tables with high data-per-row ratios, helping to improve database performance.