regarding the update to null - depending on the frequency of that table being updated you may be able to create another table with same structure (including indexes), insert all...

spam again - we really should block this thing

info is on MS licensing document itself - if that one is wrong ....

you buy the license for 2019 - and that license allows you to install 2016 as part of downgrade license terms.

see https://docs.microsoft.com/answers/storage/attachments/96089-sql-server-2019-licensing-guide.pdf - page 39

so you to install sql 2016...

that ONLINE=ON is whats causing all that growth and elapsed time.

you should also add sort_in_tempdb = on.

and... the DDL you supplied does not include the filegroup it is being created...

and information about how you are running the index creation - within a transaction, multiple index being created or just one, online or off line, sort in temp db or...

google has lots of examples - so which ones did you try and what was the result.

its not like YOU trying it will cause any issues - and you will...

you are aware that this has been answered rather often and that what you need can be found with a simple google search - not to speak on the old...

Remember, too, that the logical data model should be easily understood and use by business people.  In fact, if possible, keep all developers out of the first...

replacement for format to return just yyyy-mm-dd (or yyyy-mm) is easy - convert(char(10), datefield, 121) - change the char(10) to char(7) to return just yyyy-mm - but as mentioned...

based on the tables above and their relations I have the following comments/questions

• Ticket

  • Serviceable needs to be removed as you moved it to table Service
  • Service Category - you...

there is no SQL code on your post - only something that looks like VBA.

so do go post on a VBA or Google Sheets forum where there are bound to...

and... why you using Excel on the server? It is unsupported and likely you are breaking the licensing terms for Office/Excel.

Common approach for these is to have a set of metadata tables that contains all the information related to tables/views in such a way that you can query those tables...

For each database do ( including msdb - will allow view jobs )

GRANT VIEW DEFINITION TO [<USERNAME>]

And

USE [msdb] GO ALTER ROLE [SQLAgentReaderRole] ADD MEMBER [<username>] GO USE [msdb] GO...