Brian Sherwin's Blog

Moving at the Speed of .Net

News

Twitter

bsherwin @timwingfield Tomorrow I'll be doing a #codeandcoffee at caribou on morse and hamilton in Gahanna as well. dublin is the wrong direction. about 4 days ago

bsherwin my mustang driver side ball joint just disintegrated. good thing i was going 6 not 60mph. about 5 days ago

bsherwin RT timwingfield #codeandcoffee tomorrow morning back on Polaris. Time for me to get Git. BTW...that's Caribou on Sancus about 11 days ago

bsherwin @timwingfield Concentrate==http://www.d...html#Ghoster about 17 days ago

bsherwin @RachelAppel One last thing, avoid ones where the pwr supply is separate from the headset...the dangling cord can annoy when not plugged in about 18 days ago

bsherwin @RachelAppel BTW, "Over the ear" means "not *on* your ear". Two reasons--ear cup phones close the sound out better and no pain over time. about 18 days ago

bsherwin @RachelAppel For noise cancelling...get over the ear, I have a pair of both buds and OTE and the difference is night and day. about 18 days ago

bsherwin @jeriley Sounds like you got two Whammies...one more and you LOSE! about 23 days ago

bsherwin @jonKruger @jimHolmes @MattCastot url was auto-bitly'd...but see @MattCasto reply about 26 days ago

bsherwin @JonKruger @JimHolmes Hash tags auto create a hyperlink to http://bit.ly/4mfJnM about 26 days ago

Syndication:

RSS
ATOM

<< Moving your Log4Net configuration out of web.config with ASP.NET 2.0 web sites. | Home | When to check IsDebugEnabled when using log4net >>

Watch your procedure cache when using parameters

Dan Guzman had an enlightening post on how SQL server caches ad-hoc queries when using inline parameters. Basically the gist is that if your values for any given paramter changes you get variability in you cached procedure. However, if you specify the SqlDbType when adding your parameters, you can avoid this whole problem.

Technorati Tags: sql

posted @ Thursday, February 21, 2008 5:30 PM

Feedback

No comments posted yet.

Title:
Name:
Email:
Website:
Comment:
Verification:
	Remember Me?