I was on the Visual Studio marketplace the other day. Stumbled across this tool.

https://marketplace.visualstudio.com/items?itemName=MAQSoftware.SQLCodeCheck

I was hoping it would be a simple tool to root out basic issues in...

does not look like it - no duration, neither actual rows - only expected executions.

did you capture it yourself while executing it or through a monitor tool like SQL Monitor?

but...

that is an estimated plan, not the a actual execution plan - can you get the actual one please.

and also the view (and all sub called views).

in all likelihood all...

Do YOU maintain all of those servers or do most of the sub-companies have someone taking care of business for their...

Steve - any news on this issue?

good.

that is almost the same script I was going to send you (with a few modifications of mine)

90% of prod...

Sent you a private message.

big financial group - lots of sub companies/teams

small shop you have there.

Just on my side of the ocean we have over 750 servers (half is prod) - with a total size of 100 TB space used spread...

• This reply was modified 4 years, 1 month ago by frederico_fonseca.

moving to ssdt is not something I would advise - SSMS is a administrator tool, SSDT is a developer tool - functionality is rather different and SSDT will be missing...

touch-typist

As part of my travels through the air force (transmissions/communications) we went through intensive typing training - at start of the course we were having 12 hours a week of...

you have other views there - and views over views over views always cause issues with the query processor.

the actual explain plan for this will be useful - and all...

I find this a bit amusing - you ask for help, we give you some and we point you to...

what type of files you talking about - if SQLProjs then SSMS works differently from Visual Studio and there is no straight migration.