Herve has done some work experimenting with max degree of parallelism (DOP) on some large multi processor blocks and based on that, has some recommendations for you if you're using more than 8 processors. Good reading!
2003-06-23
30,899 reads
Bitwise operators can be challenging to manage at first. However, with practice and patience, and under the right conditions, these operators can provide remarkable performance improvements in production environments. This article will compare two methods of accomplishing the same output, one with a normalized model and the other with bitwise operators.
2002-09-05
10,463 reads
In this article, we will leverage Extended Stored Procedures to extend the functionality of SQL Server and give a starting point to experiment with Extended Stored Procedures.
2002-08-26
6,577 reads
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Last month (I ran just a little bit late writing this, it was meant...
By alevyinroc
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...
Comments posted to this topic are about the item The Growth of IQP
Comments posted to this topic are about the item How to work with Python...
Comments posted to this topic are about the item Default Raiserror Levels
Ask SSC