If you do in-line everything then contrast the execution plan with using a variable.

Hmm. Yes avoiding data type conversions is a good thing. I think that you did some other good things as well. Not repeating "[font="Courier New"]Math.PI / 180.0[/font]"...

Good point john.fuex.

The human brain is not good at perceiving steady states. It is good at perceiving deltas. You can demonstrate this with a pair of pliars and...

So I put some pen to paper. Well no I didn't. I keyed into the calculator.

$8.00 for 20 people = $160.00 per week.

Times 52 is $8,320.00 per year.

Divided...

It could be that people are forgetting about CE. Take our Sales and Delivery Force automation (part of our Scout Suite). Our main database sits between the client...

There are lots of ways to deal with this. There are tons of cheap tools that, when used together, can handle this quite well. I can get a...

YSLGuru (6/15/2010)

---

Charles,

Don’t get me wrong on this b/c I am definitely not against change, I just am not change for the sake of change or when it’s because someone wants...

YSLGuru (6/15/2010)

---

MANAGEMENT - The problem (from personal experience) is that far too foten the managemnt or decission makers are often programmers themselves and unless they have at least a respect...

I worked with...

The other, and maybe the main, reason for putting conditionals into the join is to make the query more efficient. If you blind join a table then all matching...

Phil, as for shouting the code across the crowed room you put me in mind of the late Victor Borge. The "Phonetic Punctuation" would come in handy. ...

Sure the job matters. It gives me a chance to use my skill sets to make a difference in the lives of people. Every keystroke that I can...

Nice article. Well done.

I was wondering how this stacks up...

alen teplitsky (5/13/2010)

---

i haven't done the cost analysis, but for a medium to larger environment i think tape and local onsite backups are cheaper. LTO-4 tape is dirt cheap and...

Exactly right. Now notice that all I would have to do is replace INSERT...