Thanks a lot. Comprehension is vital for me to make the correct conclusions after running my baseline tests on different setups. I conclude SQL Server is cool in...

Hello Gail,

I could not move my mind away from this topic. After my last reply, I kept thinking about the statement "checkpoints can write uncommitted dirty pages to disk"...

Hello Gail,

Thank you for the extensive answer.

It makes sense to me that 5.000.000 transactions in the logfile instead of 1 transaction (for inserting 5.000.000 rows) might have impact on the...

Hello Gail,

Thanks for clarifying that. Now I wonder whether you can have two versions of the same page in a datafile? In my insert test that will not...

Thanks a lot for this link!

The article contains some technical aspects I have never looked at so far, so I'll have to invest some time to completly understand the process,...

I found the cause.

Each 10.000 rows I execute select count(*) on table in which I insert the 5.000.000 rows.

This causes the enormous number of reads and explains why the lead...

Hi,

Does the database on SQL2014 has compatibility level 120?

In that case you may want to change it to 110 or 100 and run your test again, since 2014 uses other...

I have added the complete sql script here ...

http://www.hoveseliga.be/images/perftest.txt

so you can copy/paste it into SSMS.

http://www.hoveseliga.be/images/perftest.txt

It consists of several steps

- CREATING TEST DATABASE

- CORRECTING DATABASE SETTINGS

-...

A screenshot of the script to complete my post.

Kind regards

Peter

So this will the do it for me ...

FETCH ... @key, @f1, @2, ...

IF NOT EXISTS (SELECT ... WHERE = @key)

BEGIN

INSERT ...

END

ELSE

BEGIN

...

Hi,

To NULL or not to NULL. Its perhaps my IQ, but after years I'm still struggling with nulls. I consequently used to implement default values instead of NULLs,...

Hi,

I just had the same issue and it was caused by a trigger that stores all updates in an audit table. The audit table stores some additional information as...