So in relation to your wife, what's the difference between union and union all? plz keep it PG! ;-):-P

And here's the free version link :

http://downloads.sqlservercentral.com/Books/dissecting_complete.pdf?utm_source=ssc&utm_medium=weblink&utm_content=Grant&utm_campaign=sqltoolbelt

Has this application been upgraded from 2000 to...

If RS is a pretty big PITA in that regard. The problem with that function is that you need to copy it everywhere and it slows down execution. ...

The id has to be unique... the name of customer might repeat, but even then you need a way to differentiate the duplicates.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

We're so geeks to fight over this!

Ya but all of them are pretty hugle hacks... and you better hope that the query doesn't take 12 hours before failing!

Phil Parkin (5/26/2011)

---

"This kind of data" does not really cut it as far as a spec is concerned. Also, this is not strictly duplicate data.

So far, my spec would be...

Awesome, I had to talk about it... you'd be surprised by the # of people who don't know the difference.!!

jpSQLDude (5/26/2011)

---

Thanks for the link! And I think this might be an even more robust Index maintenance script (and other things)...

http://ola.hallengren.com/Documentation.html#IndexOptimize

Unfortunately in my production...

jpSQLDude (5/26/2011)

---

Thanks for the link! And I think this might be an even more robust Index maintenance script (and other things)...

http://ola.hallengren.com/Documentation.html#IndexOptimize

Unfortunately in my production...

Vicki Peters (5/26/2011)

---

Ninja's_RGR'us (5/26/2011)

---

Union or union all? That could make a...

Those are all the possible cases of duplicates??? Are you sure you parsed all the data yet?

Well I'm already contracting so I guess I don't have...