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 4 years, 10 months ago by YSLGuru.
• This reply was modified 4 years, 10 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...

UPDATE: I think I found the problem and the error is on my side. I made some assumptions about the DB I'm working with right now (not our regular DB) ...

Those work but not for tables just other objects like Stored Procs.

If I have a table named MYPARENT and there are 5 other tables that each have a foreign Key...