Sql Server and Duplicate Indexes

Please note that I'm not a DBA, nor do I profess to be all knowing when it comes to SQL Server, these are observations I've made over the years that I think people may find benefit from. Introduction Everyone should know that indexes on a database are both useful and to be feared! One of... Continue Reading →

My SQLServer nightmare

So we had an interesting issue this week which was bugging the hell out of myself and our technical services team that deploy our software (developed by a third party). The issue was a severe performance degradation on a certain search field in the application. First off, the code that for this site is around... Continue Reading →

WordPress.com.

Up ↑