FYI...

Per recommendation I created 3 temp tables  by breaking up the 3 queries and adding an INSERT command to create temp tables. I then compared the 3 temp tables using...

Not that it matters for this but just to be clear this is not something I made and if we figure out whats wrong with it I can't make any...

So could not upload the XML plan as a txt file so I'll see if it will let me do it if its archived (winrar)

UPDATE

So the site will not let...

• This reply was modified 5 years, 7 months ago by YSLGuru.
• This reply was modified 5 years, 7 months ago by YSLGuru.

We're having some performance issues today and so I don't want to run the Get Actual Plan piece of Plan Explorer until those are resolved. Attached are the XML plan...

Yesterday I let PE (Plan Explorer) do its thing with get the actual plan. I knew it would take some time which was fine. I was working remotely and got...

Thanks Jeff & Scott for taking the time to reply. It may sound like a dumb question but I asked anyway because the hardware/network folks keeping trying to say that...

So I tried sharing the plan (as XML) on Brent Ozars site but the result is grater then the 2MB max.

Once I have an estimated plan window in SSMS and...

Are there any performance or blocking issues with using the Plan Explorer? I had the thing running for all 3 queries with the UNION All and I started to get...

When I read your post I assumed you were referring some online tool like thing similar to another online SQL tool that will format your query. I have DL'd and...

Thanks to everyone who replied to a post with no DDL.  I cant post the code for security reasons and I had NO IDEA sql sentry could be used to...

Are there other admin only features? Possibly. I'm sure there are some, and some aren't likely to be released because they're admin things, but we often do test some things...

Any chance that's not the only thing that's available to Admins but no one else? That could help explain why regular users have problems with the forums functionality while the...

Steve,

I did not provide any specifics like a link to the exact post because it was meant as an example of a bigger problem and not a specific instance to...

Thanks for taking the time to reply. I tried to move the post to another location b/c I thought no one would see it here since the SOX section is...

Ignore my original post as I have my answer (at least what I was seeking as an answer). I would delete the post but I can;t see a way to...