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,...

Yep. In the properties. And yes, it needs to go in my book. That's one of the MANY things that are going to get added in the rewrite.

Oops. I spend most of my time in 2008 these days. I tend to bleed that stuff back down the chain sometimes.

There are a few ways. You can modify the proc to include WITH RECOMPILE as a hint, I don't suggest that though. Another way is to get the plan handle...

Right out of the gate, you've got a DISTINCT and a GROUP BY. That's an aggregate operation on an aggregate operation. I'd try to eliminate the DISTINCT from the query.

Looking...

I very strongly recommend you get a copy of Don Jones book, PowerShell 2.0 TFM. It doesn't get into SQL Server much at all, but it will give a very...

Excellent article. Clearly articulated and great examples. Thanks.

It's describing the amount of memory used to store temporary row data for sorts & other operations. Here's a great blog entry from MS on it.