SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Herve Roggero

SQLServerCentral.com profile

Herve Roggero (MCSD, MCDBA) is an Integration Architect with Unisys and works on Windows Datacenter and SQL Server running on 32 processors (and it rocks!). Herve has experience in several industries including retail, real estate and insurance. First contact with RDBMS was in the early 90's. Herve is a member of the Chicago SQL Server user group. Hobbies: Piano and Star Gazing.

   Items 1 to 3 of 3   

Managing Max Degree of Parallelism

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!   Read more...
By Herve Roggero 2003/06/23 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 30,295 reads

Using Bitwise Operators to Boost Performance

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.   Read more...
By Herve Roggero 2002/09/05 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,621 reads

DoEvents with SQL Server 2000 and Extended Procedures

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.   Read more...
By Herve Roggero 2002/08/26 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 6,218 reads
   Items 1 to 3 of 3