This is a helpful article with a lot of useful tips and documentation to support those tips.

One thing I noticed missing is location of creating temporary tables in stored procedures. ...

All of those UNIONs are creating an insane query plan.

The following code will produce almost the same result, with a MUCH better query plan.

If you change UNION to UNION ALL...

Thanks for your continued assistance.  I have tried process monitor and there is a lot of data in there!  It actually helped me with a different issue, but in this...

I should also point out another strange thing.  We have a .NET application with the report viewer in it, so we execute the reports via the ReportServer API and pull...

Irish Flyer (6/9/2015)

---

Your article is incomplete without adding that a SELECT INTO is considered a DDL statement and completely locks both source and target tables for the duration of its...

I've had trouble with SSIS and DLLs when installing in the GAC. It seems to not recognize them in SSIS packages. The way I get DLLs to work...

I totally spaced on when this article came out and the fact that I responded to it previously :hehe:

One thing I didn't mention then that is helpful to communicate is...

Thanks for the good article.

Just as a comment (not on your article specifically), did you notice that the EOMONTH returns a DATE instead of what the tooltip reads (DATETIME)? ...

With SoftArtisans ExcelWriter, you don't need...

Very interesting and helpful article. I love the open source and free availability to the DLL you provided. That said, we do a lot of advanced Excel manipulation...

Good explanation. I saw what was coming on your first SQL example right away (as some others did) when the use of "SELECT *" was there.

It is very interesting to note this is possible, however as others have mentioned, it has significant drawbacks. You must have Excel installed on the server, for example....