Insightful , thank you for the information. One comment I do have

"If the database is accessible, take the backup. The backup might be used to restore the data which is...

MSSQL has a similar function, but at the DB level, so we have an associated database to the main one, which contains something like logs and performance monitor data....

Simple and to the point, thank you. Another interesting exercise would be where you have a table partitioned across file groups. It would be interesting to see how restoring (for...

Thank you for the good point you make. Indeed indexes do help with isolating transactions and avoiding contention on a common resource.

I do want to note some areas where I...

One would be wise to consider that a HR survey may be a backdoor to find people who are not content in their job, instead of a genuine opportunity for...

Thank you, this is helpful information. If the data values of a column are more evenly distributed then the idea is that the three plans will be similar if not...

You posted "After you create the Availability Group, SQL Server automatically adds two additional system databases—SQLAG-2022_master and SQLAG-2022_msdb". However, in the picture the new system databases are not in the...

Here is an illustration of the basic commands, from here you can learn what each means. You probably will only need to use a few.

Thank you for the informative article. I think a diagram of the work flow would provide a better understanding.

I would guess the answer lies in upgrading the design of the database so less of the values you are after need to be calculated with an inner select that...

It would be good to see the actual SELECT from that table. As mentioned before there could be function(s) there. Another possibility is a cartersian join.

"The maintenance installation script that creates all of the stored procedures is over 9000 lines. I am not going to spend the hours reviewing that "

I dont review the 9000 lines...

Thank you for taking the time to experiment and share your findings. This is important to note. I wonder though, if you would temporary switch the recovery_model to bulk_insert ,...

"determine whether the query optimizer chose to use a primary key index"

The execution plan will definitely provide that information. However so would sys.dm_db_index_usage_stats in controlled cases where you know...

The functions look quite standard. I could port these from SQL Server (not sure about the agg function though).