Why you should not update Primary Key values

Recently I had the chance to take a look at a problematic query in an application. I caught the query in profiler and it’s the following: [crayon-5e9656615f713397718274/] The query...

Advice for MAXDOP setting

This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much on the forums and there are different recommendations...

Advice for MAXDOP setting

This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much...

Advice for MAXDOP setting

This post is for the MAXDOP option - how to set it in a SQL Server instance. The option is discussed much...

Advice for MAXDOP setting

This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much on the forums and there are different recommendations...

Composite foreign key

A look on the CXPACKET wait type

I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...

A look on the CXPACKET wait type

I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...

A look on the CXPACKET wait type

I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...

A look on the CXPACKET wait type

I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...