Category Archives: Development

Why is my stored proc slow in .Net?

I was writing a stored procedure the other day and trying to make it run faster. The problem was that it ran in under a second in SQL Server Management Studio, but then took over thirty seconds when running from … Continue reading

Posted in Development | Tagged , | Leave a comment

How to convert a test project to a normal class library

Sometimes you make mistakes. One of the ones I make most often while using Visual Studio is creating a new project of the wrong type. Usually, creating using just the same one I usually created. And just now, I added … Continue reading

Posted in Development | Tagged , | Leave a comment

Convert Access 2007 forms to 97

You might be surprised by this, but you can still back convert Access 2007 forms, reports and modules to Access 97! (Why is another matter, of course, but let’s presume that you need to…) OK, first of all, you need … Continue reading

Posted in Development | Tagged , , , | Leave a comment