AzureSQL
AzureSQL copied to clipboard
yochananrachamim
`ALTER TABLE [vf].[v_matter] REBUILD ;` `FAILED : 46518The feature 'ALTER TABLE' is not supported with external tables.` It bashes on past this, but obviously the script then ends in the...
Get index information per tables instead of once for all tables This will allow us more flexibility with per table maintenance. for big databases it is taking time to get...
Anti-Semi-Join against sys.external_tables on matching object_id to exclude External Tables Also fix for ignoring TVFs - the [type] column is a 1 or 2 letter code, 'TF' for Table Valued...
Our nightly run of AzureSQLMaintenance tends to plateau our DTUs at 100% for about 2 hours. We've narrowed down the culprit to an `UPDATE STATISTICS` call on a single, particularly...
for scenario where we have large tables and we do not want to go through all the data for the stats update it would help to have some control for...
On a SQL17 instance, Developer Edition (64-bit), we have a table with FILESTREAM columns. When `AzureSQLMaintenance` (current version) decides that its PK be rebuilt we get: >ALTER INDEX [PK_Medium] ON...
Accept a new options for @operation called "versioncheck" or similar Perform no maintenance and just return a @version value. That way in our automated jobs we can detect whether we...
Procedure fails when it tries to do rebuild on Clustered Column Store Index: ` ALTER INDEX [TableName] REBUILD WITH(ONLINE=ON,MAXDOP=1, RESUMABLE=ON);` Error: `Msg 35397, Level 16, State 1, Line 1 alter...
