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,843 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,170 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,542 reads
By kleegeek
We’ve been tracking a weird state with SQL Server virtual machines on VMware and...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
A client of ours is upgrading their database to SQL Server 2019. The edition...
Hi, I need to perform backup and save it in network drive. I have...
Hello Group, Do you have any available extended events to capture the queries run...
Ask SSC