Sean Lange (2/14/2014)

---

SQLRNNR (2/14/2014)

---

I have seen that kluge query method work much faster and I have seen it be slower. It all depends. It would be well worth...

I have seen that kluge query method work much faster and I have seen it be slower. It all depends. It would be well worth testing and demonstrating...

Thanks for sharing this script

I have an article with a tsql script on how to do that. You could use that script if you prefer. You will probably need to make some...

Here's another option if you are interested

http://jasonbrimhall.info/2011/12/05/database-data-and-log-size-info/

and more granular detail

http://jasonbrimhall.info/2011/11/21/table-space-cs-part-deux/

Thomas Abraham (2/14/2014)

---

My experience is that $ spent on Valentine's Day, or any odd Wednesday, on flowers/jewelry/chocolate/stuffed animals/etc....

Attack

Greg Edwards-268690 (2/14/2014)

---

SQLRNNR (2/14/2014)

---

Greg Edwards-268690 (2/14/2014)

---

Help improves when you post scripts for table structures and some sample data, along with the select statement.

Usually when you get multiple records, a join...

James Horsley (2/14/2014)

---

I mainly...

I am...

I don't see anything (in common between the two) in that sample data that could help prevent the Cartesian product except maybe the dates.

Or maybe...

breakfast

Oh too true :cool::cool:

Nice article Wayne.