Recently, at a SQL Server conference, the parallelism topic was brought up. One of the participants in the conversation expressed opinion that once the parallelism for the SQL Server instance is disabled, there is no way a query will be executed in parallel.
At the time I just expressed my doubt and my hope that this
Continue reading […] SQL Server parallelism on server level and MAXDOP […]
Here is a real life example of a great concept: great unpaved shortcuts in their glory.
Pave the shortcuts!
The reality is that if there is a well-stomped shortcut somewhere, then it should definitely be paved. After all, it is well-stomped because many have taken it. And if many have taken a shortcut, this means
Continue reading […] Pave the shortcuts! […]