I may be braindead today but I only kind of follow the problem.

You're getting the null join because you're using a left join.

More than one value is usually a problem...

Sean Lange (6/10/2013)

---

Evil Kraig F (6/10/2013)

---

I don't argue with H.L. Mencken's philosophy, but noone ever got rich trying to make a spreadsheet software using a pac-man interface, either.

If you can't...

I don't argue with H.L. Mencken's philosophy, but noone ever got rich trying to make a spreadsheet software using a pac-man interface, either.

If you can't trust your users, they won't...

sudhirnune (6/8/2013)

---

Additionally, is there an index on the field you're looking to partition across? I'm wondering if the statistics are just wildly off. If there's an index on that field,...

I figure it's not a bad idea to chime in here. My current DBA (I'm playing little ol' developer at the moment) is beating his head on the walls...

I just want to clarify, you're looking to setup table partitioning within the schema of the database to multiple filegroups, correct? The reason I'm trying to clarify is because...

curious_sqldba (6/6/2013)

---

Stand alone server with SAN. Actually this is weird, because when i have the perfmon running in background physical and logical readings are similar but if i have it...

ScottPletcher (6/6/2013)

---

What "expansion"??? This is an interview q only to test thinking ability, like "How many manhole covers are there in NYC?" and other MS classics.

At one point in...

This sounds like a homework question. What you want is Foreign Keys and Relational Integrity. Use those as your keywords for google and you'll find what you're looking...

ScottPletcher (6/6/2013)

---

Evil Kraig F (6/6/2013)

---

ScottPletcher (6/6/2013)

---

Dird (6/6/2013)

---

Yeah, the Q as a whole is a bit meh. I assume he means AVG (to go with the MIN/MAX functions) which...

How close are you to the drives? Are they a raid hanging directly off the machine in question? Are you working through a SAN? Are you on...

ScottPletcher (6/6/2013)

---

Dird (6/6/2013)

---

Yeah, the Q as a whole is a bit meh. I assume he means AVG (to go with the MIN/MAX functions) which I don't see as...

cherbik (6/6/2013)

---

I am new to SSIS. There is a data flow task for a derived column. I want to have a Derived Column that only looks at the...

David,

I wanted to thank you for this well laid out walk through of your experiences with Hadoop. The article is rather informative and shows the difficulties in switching from...

You've hit pretty much all the nails on the head for this. You either need to license a server to your job server, or run it via a foreign...