-
Thinking of changing hosting company
I purchased shared hosting service from Midphase years ago and that is where this site is hosted. It is up for renewal before 10/11. Every year during this time, for the last 2 or 3 years, I toyed with the idea of switching to a different hosting company, because the inflexibility of not having root…
-
One example of query performance problem due to data type conversion
In many RDBMS systems, if the value(s) passed to a query for filtering/matching is of different data type than the column data type it is comparing against, an implicit data conversion occurs. This conversion can render the index defined on said column(s) less useful or entirely useless. I encountered one such problem on SQL Server…