Poor man’s full text search for SuiteCRM
The poor man’s CRM, a.k.a SuiteCRM … … Continue readingPoor man’s full text search for SuiteCRM
MySQL Error: Thread stack overrun
Recently, I’ve come across this error … … Continue readingMySQL Error: Thread stack overrun
Recursive Relationships in Databases
One of the tricky issues in entity relationship model is the recursive relationships. Sometimes an entity needs to refer to itself. … Continue readingRecursive Relationships in Databases
To upgrade or not to upgrade XAMPP 1.7.3
XAMPP is just another package of… … Continue readingTo upgrade or not to upgrade XAMPP 1.7.3
Paging records in MS SQL Server 2005
After years of torturing their SQL Server users, Microsoft provided a “better” way of paging records in version 2005, and it is a weird one! The following example is from their website, an article about ROW_NUMBER (Transact-SQL). … Continue readingPaging records in MS SQL Server 2005