Is max memory for the sql server instance set to lower than  839GB, so other applications like the operating system can run?

Is SSAS installed on the server? There was a...

Happy thanksgiving. Hopefully next year in different circumstances

You might want to try out table/index pagecompression to reduce the size

There are no more servicepacks since SQL 2017 as part of the cloudfirst strategy. Currently at update 22. https://sqlserverbuilds.blogspot.com/

*edit* You might consider SQL Server 2019 is your project is still...

• This reply was modified 5 years ago by Jo Pattyn.

In Belgium were are back in lockdown mode. Most shops have to close.

For the spookiest year , I nominate the year the asteroid hit Earth and wiped out the dinosaurs

7) Why are you still on 2017 RTM

Sounds right. Largely depends on the goal of insert/update/delete

don't use big transaction -> big transactions lead to longer locking times, greater chances to fill up disk space

perform insert?delete and update...

That doesn't sound too well. Prepare to restore the database to another server from a previous backup.

Does the operating system reports IO problems outside of SQL Server?

Does your storage /...

Reasons why I go to/follow conferences:

General scope of what lives amongst the community: what are the new things, what is getting obsolete. .Net or .Net core etc

Some in-depth sessions about...

Was thinking about adding a computed column to the table and adding an index on it. Still a problem if you have multiple TRAN_TYPE per TRAN_AUTH_ID as the index might...

(size of data table t1 + size of t2 join fields) * (number of rows in t2) ? SQL Server estimates it . Can be lower if data is streamed...

• This reply was modified 5 years, 2 months ago by Jo Pattyn.

I don't think that Read-Committed Snapshot isolation would help. Would be strange/bulky that sql server to keep the meta data of the table per new insert/update/delete

Changes to tablestructure takes a...

My experience:

Standalone config inplace upgrade december 2019 -> may 2020:

After upgrade it refused to recognise its configuration file. Solved after a repair installation. Still in test-phase. New powerbi reportbuilder will...

Getting stackdumps is not a good sign.

Have you verified the integrity of the databases (DBCC checkdb)

On what patchlevel is the sql server 2014 instance

As you work with maintanceplans, I assume...

• This reply was modified 5 years, 3 months ago by Jo Pattyn.

15 min for one row is indeed very long.

Number of views shouldn't affect it unless it's an indexed view.

The number of indexes affected, more indexes: more housekeeping to keep everything...