A team mate of mine manage to bring the restore time back to the initial speed by using this 2 parameters during the restore MAXTRANSFERSIZE & BUFFERCOUNT. However none of...

The target server is basically an empty server hosting SQL 2022 it hasn't gone live yet, thus no jobs running there. So I could say no changes was done at...

Thanks for all the reply.

Just 1 more thing to clarify, if I were to upgrade my database from SQL 2012 to SQL 2019 & I want to retain...

Thanks for all the reply.

Just 1 more thing to clarify, if I were to upgrade my database from SQL 2012 to SQL 2019 & I want to retain all my...

Ok... good.

1. What is populating the [D_ID]?  A SEQUENCE?

You have nullable columns and, because you have PAGE compression turned on, almost all of the columns (even the supposed fixed...

Hi All,

First of all, thank you for taking your time to reply on this post & also sorry for the late replies as I'm a bit tied up with other...

On the subject of the backup failure...

IMHO (and experience but YMMV), it's a complete waste of time to backup a 2TB log file (happened to me the 2nd day...

If partitioning IS present, why is there a need for any of this?  SWITCH the old data out.  Copy it to a new table in the archive.  Then SWITCH...

No I have not. I'm mainly doing general administrator for the DB, the query itself is developed by my application...

1.  I forgot about table partitioning.  That answers my question there.
2. If the database is in the FULL Recovery Model, I recommend temporarily shifting to the BULK LOGGED Recovery...

I'm trying to create a clustered index on a very large heap table. Below is the script i'm using to perform the creation job.

CREATE CLUSTERED...

If you've been running without partitions for 12 years or so, why add them back? Partitions are all about data management, not performance. If you're not dealing with all...

Hi All,

Thank you so much for your replies. Just to add on, does Microsoft mention anything about having a primary constraint and table partition together? As far as I know...

instead of a Primary Key you can define it as a Unique Index.

one of your issues is how you ensure that GSN_ID remains unique throughout the table. - a...

Here's the create index statement which the developers run.

Create NONCLUSTERED INDEX [IX_TileID_Include] ON [DB01].[dbo].[table1] ([Tile_ID]) INCLUDE ([Die_ID],[GGI_ID],[GGI_X],[GGI_Y],[DS1_ID],[DS1_X],[DS1_Y]) with (DATA_COMPRESSION = PAGE, ONLINE=ON)

As for the server spec, it's a VM server...