spirit1


Comments:

IDisposable – 1, 2, 3, …

posted by spirit1spirit1(3160) 4 years, 11 months ago 0

awsome

Reply

Become a Better Developer in 6 months. How?

posted by spirit1spirit1(3160) 4 years, 10 months ago 0

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

Reply

SQL Server 2005: An error or intended behavior with Database Compatibi

posted by spirit1spirit1(3160) 4 years, 8 months ago 0

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

Reply

.Net Windows Forms ListView ColumnHeader width tip. Set it to -1 or -2

posted by spirit1spirit1(3160) 4 years, 8 months ago 0

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 :)

Reply

Reporting Exceptions through E-Mail

posted by spirit1spirit1(3160) 4 years, 8 months ago 0

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

Reply

.Net: Passing user data with Exception back to the caller method

posted by spirit1spirit1(3160) 4 years, 8 months ago 0

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

Reply

The WaterHobo

posted by spirit1spirit1(3160) 4 years, 7 months ago 0

i liked it!

Reply

SQL Server: The one and only locale insensitive date format

posted by spirit1spirit1(3160) 4 years, 7 months ago 0

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.

Reply

C#: Care about Event Memory Leaks with Delegate.GetInvocationList()

posted by spirit1spirit1(3160) 4 years, 7 months ago 0

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?

Reply

10 reasons why I chose MySQL over MSSQL2005 Express

posted by spirit1spirit1(3160) 4 years, 4 months ago 0

in express you can easily achieve this with row_number function.

Reply

Don't Use SELECT *

posted by spirit1spirit1(3160) 3 years, 10 months ago 0

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!

Reply

DotNetFunda Is A Disgrace.

posted by spirit1spirit1(3160) 3 years, 7 months ago 0

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.

Reply