acctually i also don't agree with some of the things on that site but still... come on people... every contribution out there helps someone with something. and that's a good thing.
the whole point of the internet is to share different views and opinions. not everyone agress with everything...

@dotnetfunda:
i think you should reenable that "code points etc" article for the resons i said above.

as good as this advice is the first execution plan has nothing to do with the * itself.
It is showing a bookmark lookup that will happen for every query when you're filtering on a column that has a non clustered index and
columns in the select list that are not covered by a non clustered index.
because data is stored in the leaf level of the CI a bookmark look up is looking up that data in the CI.

just to clear thing up :))

other than that the advice is sound!

in express you can easily achieve this with row_number function.

true. i was proven wrong and i'm thankfull for it. for me this is a good thing since i've learned a new thing. and that's always good, right? :))
if i'm not mistaken my example would have to be reversed.
for the leak to occur the form should have to be subscribed to an event on the original class that owns the form.
since then closing the form wouldn't magicaly unsubscribe the event subscribtion to the original class from where you called form.Show().
correct?

yes it wouldn't and that is exactly the point of the post.
yyyy-dd-mm isn't locale / date format insensitive so it can't be used by default.

i liked it!

it seems not everythign is bread and butter:
http://weblogs.asp.net/fbouma/archive/2007/10/04/don-t-look-at-the-sourcecode-of-net-licensed-under-the-reference-license.aspx

see. i knew it's easily overlooked :))

if the smtp fails i usually write it to a file or event log

thanx!

i can't believe it... it happened again... that's it! i'm stopping generating friendly url names... they don't play nice with dotnetkicks :)

my blog software somehow managed to change this link after i posted it. I've mailed Gavin asking him what to do.
for now the working link is this:
http://weblogs.sqlteam.com/mladenp/archive/2007/08/30/60313.aspx

@All:
i'm glad you like it :))

awsome