Posts
832
Comments
691
Trackbacks
1
December 2005 Blog Posts
Slow Stored Procedure Execution

Suppose you have a stored procedure that runs fine in one environment, but slower in another.  You check to make sure all the underlying indexes exist.  You recompile it a couple of times.  Still, it doesn't perform as it should.

Try:

Update Statistics tablename

posted @ Wednesday, December 28, 2005 5:03 PM | Feedback (0)
.NET interview questions

I think these are pretty silly, but they are interesting lists to look at:

http://www.hanselman.com/blog/ASPNETInterviewQuestions.aspx

http://www.hanselman.com/blog/WhatGreatNETDevelopersOughtToKnowMoreNETInterviewQuestions.aspx

posted @ Wednesday, December 28, 2005 5:02 PM | Feedback (8)
.NET: How do I get to the System Colors?

For whatever reason, you can't do System.Drawing.Color.Control or System.Drawing.Color.Default, or whatever. 

Instead, you need to do something like System.Drawing.SystemColors.Control.

posted @ Tuesday, December 13, 2005 12:32 PM | Feedback (0)
Could not transform licenses file into a binary resource

This error shows up in Visual Studio from time to time when using third party components with Windows Forms and trying to compile, often with an accompanying qualifier: “could not create type.”  When this happens, delete the existing licenses.licx file.  Then open all of the forms and make a tiny change and then reverse it (so for instance, I change the location of a control by one pixel, and then put it back to its original location).

The project should now build.

posted @ Tuesday, December 06, 2005 10:19 AM | Feedback (0)