Si vis pacem, para sql

Recently I had the chance to take a look at a problematic query in an application. I caught the query...

2015-11-11

3,403 reads

Sql Hints #1 - Don’t update Primary Key values

by Igor Micev

Si vis pacem, para sql

Recently I had the chance to take a look at a problematic query in an application. I caught the query...

2015-11-11

110 reads

Advice for MAXDOP setting

by Igor Micev

Si vis pacem, para sql

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

2015-10-16

18 reads

Advice for MAXDOP setting

by Igor Micev

Si vis pacem, para sql

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

2015-10-16

14 reads

Advice for MAXDOP setting

by Igor Micev

Si vis pacem, para sql

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

2015-10-16

202 reads

Advice for MAXDOP setting

by Igor Micev

Si vis pacem, para sql

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

2015-10-16

873 reads

A look on the CXPACKET wait type

by Igor Micev

Si vis pacem, para sql

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

2015-09-10

7 reads

A look on the CXPACKET wait type

by Igor Micev

Si vis pacem, para sql

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

2015-09-10

40 reads