Month: August 2008

August 19, 2008

One of the common problems that you would encounter when you are building applications that utilize views is that sometimes there are cases wherein a view gets out of date. This happens when you add a new column to a table a view is refrencing. To fix this some people would delete the view and […]

Continue Reading
August 19, 2008

I’ve been doing a  lot of code deployments lately and I’ve come across several occasions wherein my stored procedures wouldn’t run as fast as expected compared to it’s previously known execution time. The problem lies on the statistics not getting updated after change has been made against an index or other object that may affect efficiency. […]

Continue Reading
August 19, 2008

Ever thought of how to capitalize the first letter of every word in a string? Here’s how: [C#]

[VB.NET]

HTH

Continue Reading