Hi

There is no index recomendation because optimisation level = TRIVIAL. If you change the query so that its level is FULL, without changing the results, you will also see the...

• This reply was modified 1 year, 11 months ago by  aksel.rohtsalu.

here is the reason - Open TCP port 2382 when installing a named instance. Named instances use dynamic port assignments. As the discovery service for Analysis Services, SQL Server Browser...

Hi
Check SQL Server 2012 Database Administration (70-462) in pluralsight

https://app.pluralsight.com/library/courses/sql-2012-database-administration-pt1/table-of-contents 
https://app.pluralsight.com/library/courses/sql-2012-database-administration-pt2/table-of-contents
https://app.pluralsight.com/library/courses/sql-2012-database-administration-pt3/table-of-contents

regards
Aksel

hi

yes - this script just inform, if some db needs more exploration (if you have lots servers & lots db-s then it is helpful).

i run this script periodically -...

🙂

tnx