GilaMonster (2/2/2012)

---

Anyone interested in proof-reading an article on bulk-logged recovery and minimally logged operations? It's titled as an introductory article, but I read the log and might end up with...

Here's another article to help understand the process.

http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/

http://www.baseball-reference.com/players/p/putzjj01.shtml

You can't run an SSIS 2008 package from SSIS 2005. You need to have SSIS 2008 installed somewhere and run the package from that server.

Duplicate post

Post answers here

http://www.sqlservercentral.com/Forums/Topic1245741-364-1.aspx

putz

Are you executing a 2008 package against a 2005 database or are you trying to...

If the values are the same in the column used in the order by, the results will be random. You may see the same order of the results after...

Recurs1on (2/2/2012)

---

We see this kind of thing all the time. In our case, it's not a dramatic as in yours, but we'll have procedures that take 1min to run the...

Thanks Steve

That last order by statement. But I wouldn't be surprised to see other sort operations if the query were to complete and an execution plan could be generated. ...

It also looks like you will be seeing a significant sort operation.

The query is filling up the tempdb probably due to the size of the tables in the query. Reduce the result set and likelihood of filling up the tempdb...

Excellent dog!!!!!!!!!!

Any good reason a where clause is not being used?