I'm quite usually more busy on the weekends than during the week. So I don't often get to hit SSC on the weekend.

Take a look for "parameter sniffing" online. Gail Shaw's blog has a great article on it. (Blog URL is http://sqlinthewild.co.za/)

If you use "left(Territory_ID, 4)" in your Select and your Group By, will that do what you need?

Costs aren't really all that reliable. They can be either artificially high or artificially low.

Why two inserts into temp tables and then a join? Why not just build...

You would need to add Col2 to the Group By clause, for that to work.

If you Bing/Google "average salary", the first results should give you what you're looking for. For example, swz.salary.com, given a job and a Zip code, can tell you what's...

If I understand you correctly, you want to check if there are two rows in the inserted table that have a specific value in one column. Is that correct?

If...

The point of the data about birthdate and Zip code isn't that knowing those allows someone to figure out who you are, it's that those data are adequate to operate...

Steve Jones - Editor (8/28/2009)

---

Great analysis, GSquared, but it also means that we are assuming that the botnet doesn't get a hash of the password.

To me that's the bigger...

Jeff Moden (8/29/2009)

---

That might be nice but I'd rather see them spend the time on improvements to SQL Server itself. For example... some better IO functions for T-SQL. ...

IceDread (8/30/2009)

---

Jeff Moden (8/30/2009)

---

Can you give some specific...

Just to add to it: Grats, Roy! Well done!

kevin77 (8/28/2009)

---

GSquared's botnet math assumes that the more bots you add, the faster the password will get hacked. While there is obviously nothing wrong with the math, and I...

bob.willsie (8/28/2009)

---

Excellent analysis Gus. The only hole I see is that many systems remove a lockout after 15 or 30 minutes. However I suspect bots would be designed...

GilaMonster (8/28/2009)

---

GSquared (8/28/2009)

---

He actually insisted that dressing well helps to prove competence. Not, "dressing well shows a degree of respect for the people you are interviewing with, and a...