Paul White (9/5/2009)

---

It would be interesting to know if the procedure is still slow when called with the WITH RECOMPILE option.

For example EXECUTE dbo.SuddenlySlowProc WITH RECOMPILE;

I suspect the SELECT INTO...

GSquared (9/4/2009)

---

All the proc does is populate a temp table, then run that sp_transform proc.

This means that there are three things that could be slow:

1. The view

2. Creating...

Hi GSquared,

sp_transform changes type of view report, but there is no problem with this, even i disabled this...