krypto69 (10/25/2010)

---

I cleared...

Jack Corbett (10/25/2010)

---

So I got an email from a friend this morning asking for some SQL help. They are running a system that used to have multiple databases per...

If scans/seeks/whatever, if...

Have statistics been updated on both servers? The indexes rebuilt the same way? Besides the version of sQL Server, is there more/less memory, faster/slower processors, more/fewer disk drives, more/fewer drive...

Maybe, so you have data that is suspect, like it might not have the right data types in a column or something? The only way to be sure ahead of...

Jeff Moden (10/24/2010)

---

I'm not sure why everyone thinks this stuff has to be done in a single query. And, it probably should NOT be done in a single query....

george sibbald (10/24/2010)

---

I'm interested, why use SSIS for backup plans? That does seem an unnecessary extra layer to me. I presume you mean outside of the maintenance plans.

Whats the...

Stefan Krzywicki (10/23/2010)

---

Grant Fritchey (10/23/2010)

---

The key to learning SSIS, at least for me, was to learn to trust the pipeline. As soon as you focus your efforts around keeping the...

Absolutely do not use a table valued function for this. Those things are notorious. Since you're saying you can't see it in the execution plan, it's a multi-statement function, right?...

You should absolutely not run profiler on a production system as was mentioned. In addition, you should output your trace to file, not a database and especially not a database...

You really don't need to start putting on index hints yet, no.

Yes, indexes work with the columns in the SELECT clause, the WHERE clause and the ON parts of the...

Have you looked into using TRY/CATCH blocks within the procedure? That's the best way I know of to handle errors.

Personally, no I wouldn't bother... but, there is a possibility, remote, rare, but certainly there, that you can get duplicates on GUIDs. So... you might want to leave it in...

The best suggestion I can give you is, instead of focusing on combining these five procedures, focus on defining the single query that will bring back what you need. Just...

The key to learning SSIS, at least for me, was to learn to trust the pipeline. As soon as you focus your efforts around keeping the data in the pipeline,...