Colorization is a task for a client application.

Sql server hosts databases with data inside. When you access the data , you use applications (like sqlcmd, management studio, etc).

If the application supports...

In Management Studio try to open the custom report attached

it will show you sqljobs time line for a whole day grouped by 30 minutes chunks (intervals)

if you click on an...

take a look

https://sqlpadre.wordpress.com/2014/02/06/sql-copilota-software-review/

PS http://www.sqlcopilot.com can't be resolved now, unfortunatelly. Perhaps some temporary issues ...

just double double quotes

=IIF(Fields!homeLanguage.Value = "Spanish"
," en ""Approved Technology"". La lista tiene tres categorías:"
, " on the ""Approved Technology"" icon. The list has three categories:")

or see the...

Brandie, thanks for clarification.

My points were posted just to let you/others know, that information in msdb can be either absent (deleted) or imported from another server (as a result of...

hi

first link in References section doesn't work

https://www.sqlservercentral.com/blogs/cleveland-dba/2012/06/07/page_verify-checksum-vs-torn-page-detection/

also, it's not clear what do you mean by the question

"In SQL Server 2017, what is the new option that should be set...

Check SQL counters "Server Target Memory" & "Server Total Memory"

Below everything is explained :

https://blobeater.blog/2017/03/01/sql-server-target-vs-total-memory/

Query to get current values :

select 
object_name
,counter_name
,cntr_value
from sys.dm_os_performance_counters 
where counter_name like 'T%Se%Memory%'

btw, two things to consider:

1. reality vs expectations

when you analyse the list of files, you analyse existing things which are really present on a disk

when you analyse backup history, you...

Statistics will follow you database because it's db backup file, unless you migrate data using BCP or ETL tools.

Also, if you have execution timings per table , you can use...

Microsoft supports database platforms (SQL server versions), not user databases.

Database compatibility level 100 (sql2008) is supported by SQL2017 (see link below).

So, as far your db (compat level 100)  is hosted...

imho, it could...

Thank you for the MSDB info. I think I might have seen that when previously trolling through the db tables, but I totally forgot it. You're right that...

Also, be aware that if you granted access to an AD group from another domain (despite trusts are in place), such AD group should be either Universal or Global type....

perhaps SQL synonyms could help, but i'm not sure and it needs testing

in general   DB.schema.object  naming convention will help you to get the data you need

like the following:

select 'db1' [db], name , type_desc

from DB1.sys.objects 

union all 

select 'db2' [db], name, type_desc

from...