multiple bulkier tables with years of data

https://www.sqlshack.com/database-table-partitioning-sql-server/

https://www.brentozar.com/archive/2012/08/potential-problems-partitioning/

I suspect the SQL Agent and system health will not be much use for this. Assuming you have the basics covered, like enough memory for Windows to run without paging...

How to backup a SQL database to an AZURE storage account using the Ola Hallengren scripts.

I am not sure what you hope to achieve by signing all the SPs with a certificate. I have only ever signed t-sql SPs when ownership chaining is not going...

• This reply was modified 3 years, 4 months ago by Ken McKelvey.

Here is an article by Brent Ozar which includes performance counters:

https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

I suspect the main use for PerfMon information is when there seems to be load on the server but...

If you have difficulty understanding joins you may want to start with a basic general SQL tutorial:

https://www.w3schools.com/sql/

If you want to learn t-sql you can read Itzik Ben-Gan's books. Maybe...

It seems to UPDATE with the first non null value it comes across.

Due to the way SQL Server is internally structured, with a small heap under low load this will...

• This reply was modified 3 years, 4 months ago by Ken McKelvey.

This might help you:

https://blog.sqlauthority.com/2012/06/04/sql-server-simple-example-to-configure-resource-governor-introduction-to-resource-governor/

Any major development environment will work with Azure SQL database. (.Net, Java, PHP, Python etc)

As you are asking this question I assume you do not have much development experience. If...

https://dev.to/vicobiscotti/finally-switching-from-microsoft-localdb-to-sqlite-29mo

CASE can only return one datatype so you will either have to cast everything to varchar(13) or use NULL for No Valid Date.

ps Instead of typing out '1900-01-01 00:00:00.000' everywhare...

• This reply was modified 3 years, 5 months ago by Ken McKelvey.

Deleted

• This reply was modified 3 years, 5 months ago by Ken McKelvey.

Your problem is almost certainly the cursor. To get any reasonable help you will need to post consumable test data and the full procedure. As well as showing the logic...

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

https://www.sqlshack.com/dynamic-pivot-tables-in-sql-server/

• This reply was modified 3 years, 6 months ago by Ken McKelvey.

You need to cast the join columns to the same collation. Ideally you should sort out the collation in the database as casting negates the use of indexes.

As you have...