I like Lowell's technique, but I'd add that if you are sending this off, I'd send to a group, even if it's just a group of one. Usually I find...

+1, congrats

The products you listed don't do all three, really. #1 and #2 are SQL Monitor. I believe that #1 and #3 are more the other products. It's really a focus...

Did those help you study/work harder?

Bill Stutters (11/14/2011)

---

I think part of the problem with the lack of people going into CS majors is that the industry has done a very poor job of selling itself....

Eric M Russell (11/10/2011)

---

Several years ago, I was watching one of those shows on cable TV where they profile real crime cases. A dead body was discovered dumped off the...

RonKyle (11/14/2011)

---

For whatever reason I have found that most of the most creative IT professionals have a degree in a non-STEM subject, if they even have a degree at all....

David Zuckerman (11/14/2011)

---

I really take personal offense at the phrase in the editorial:

"It also seems that many of the people I've met with CS degrees are often those that make...

Done,

with travel for the year. 14 events, I think 20 presentations, a long year.

Excellent time at SQLInspire in NYC this weekend. Got to shake Jason's hand (again) and chat for a few minutes. He has a great boss, who I also met.

Good luck on that. You shouldn't need IIS on the report server in 2008 anymore, but you can configure SSRS to use, or not use IIS. There could be...

What are you looking to monitor? Just server health and alerts? SQL Monitor does that. If you are looking to performance troubleshoot, you might look at SQL Sentry's Performance Advisor...

First, it doesn't matter what you might have in Excel. You need to know what's in SQL Server.

Second, formatting your code will make a lot of this easier for everyone.

Third,...

You want to be really careful with functions. You can cause lots of performance issues with using them.

That being said, it looks like you are passing unitprice and not product...

Does this help? http://voiceofthedba.wordpress.com/2011/05/23/collation-conflicts-in-a-sql-server-join/