Prepared Statements and the “Parameter X has no default value” error

Posted January 27th, 2010 by Wesley

When I stumbled upon this error “parameter @columnName has no default value”, first thing I tried was Google, of course.  When googling, I found lots of answers for this problem, but they all resulted in the following solutions:

Parameter name is different in the query and when declaring the parameter (wrong columnName, or wrong parameter assigned [...]

Tags: ado.net, DbCommand, nullable, OleDbCommand, prepared statement

Windows 7 and its System process hogging up the CPU

Posted January 14th, 2010 by Wesley

If you’re running Windows 7 and find that from time to time, you PC slows down for 5-10 seconds, try to monitor the System process (NT Kernel & System, or ntoskrnl.exe): chances are that this process is hogging the CPU.  If it is, take a look at your network adapter(s) properties and check if LMHOSTS [...]

Tags: cpu, kernel, lmhosts, performance, system, windows 7