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

I will query on the system catalogs but know that so far everything Iv'e found either works only for non-table objects (i,.e. Views, Stored Procedures, UDF's) or does not work...

• This reply was modified 4 years, 9 months ago by  YSLGuru.

Than you for the additional info/feedback Mike.

Thank you for the additional info/feedback Mike.

I think your right with the shrink file because the DB when backed up is still around the same size as when we had it ion prem.  I have another...