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
31,042 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
11,318 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,710 reads
By Kevin3NF
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...
By Steve Jones
nighthawk – n. a recurring thought that only seems to strike you late at...
I know I can use extended events (xevents) in Azure SQL DB when in...
The installation of SQL Server 2008 R2 Express on a virtual machine takes around...
Comments posted to this topic are about the item Creating Aggregates
Comments posted to this topic are about the item Getting Started with DDL statements...
Ask SSC