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, 10 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, 10 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...

Is it purely the engine or also other ms components like SSAS, SSIS, ...?

The major change is the new cardinality estimator introduced in 2014 which may effect the performance on...

Rest in peace Mike

Sad thing that it has to come so far.

SSC Rookie, if you won't install .net 3.5 I would contact MS support to see what your options are

No apology needed. Thanks for posting the solution

Original way to put the brakes on. Get better soon Jasona.

For recovery you can train your hand with edge-browser easteregg edge://surf/

I applaud to all persons who have kids at home or other people /things that demands immediate attention.

We can still go outside, which is a plus

You might want to verify the integrity of the sql 2000 backup with dbcc checkdb

Not sure when page verify Checksum was introduced (better than torn-page detection) for corruption detection

https://www.sqlskills.com/blogs/glenn/setting-your-page-verify-database-option-to-checksum/

Me neither, apparently EDI-files https://en.wikipedia.org/wiki/X12_Document_List