The account is able to access only what has been granted to the login in SQL Server and the user in each database.  If this account has higher level of...

Let's start with 3-part naming - and schema-qualifying objects.

This structure dbname..table1 tells SQL Server to look for the object in the default schema and the dbo schema.  If I created...

First things - the cursor declaration is almost certainly a dynamic cursor since that is the default.  It is a good practice to always specify how you want the cursor...

I haven't found that the SSRS matrix is any slower or faster than doing the work in SQL Server.  In fact, I have found that performing the pivot in SSRS...

I think the real problem here is that you have a cursor - and you need to debug that cursor to figure out why it is doing something you don't...

This doesn't make sense to me...

Just so you are aware - if you have decided to use the 'many' suggestions of adding multiple PIVOT statements to your query, you are going to find out (quite...

The best practice would be to create and use a proxy account - then assign the job step running the SSIS package to use that proxy account.  If you don't...

If your memory hasn't increased up to the limit of 32GB - then either SQL Server doesn't need that much memory or the instance is being restarted so it has...

Database files don't auto shrink, and we don't want them to do that.  As you add data the file will grow.

When you shrink a database file it can cause your...

First - using the truncate only option isn't going to do anything for a transaction log.  You need to specify a size - but that isn't going to help either...

Here is an article you should review: https://www.sqlservercentral.com/articles/managing-transaction-logs (also linked to in my signature).

If your database is in full recovery model - you *must* perform frequent log backups (at least...

Here is the Microsoft documentation on the subject: https://docs.microsoft.com/en-us/sql/relational-databases/reading-pages?view=sql-server-ver15

I get less concerned over the formatting of code. These days we have products like SQL Prompt and other tools that can reformat things as we need them. I...

Here is a previous discussion that give you some ideas on how to accomplish this task:

https://www.sqlservercentral.com/forums/topic/create-total-record-in-html-email/page/2

https://www.sqlservercentral.com/forums/topic/create-html-email