Herve Roggero

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.

SQLServerCentral Article

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.

5 (3)

You rated this post out of 5. Change rating

2002-09-05

11,931 reads

Blogs

How to Install DBeaver and Connect to a PostgreSQL Instance

By

Whether you’re a seasoned DBA or just exploring database tools, DBeaver offers a powerful,...

DBAs should never run SSMS under their everyday Windows account

By

 DBAs should never run SSMS under their everyday Windows account If you open SSMS under...

macOS Tahoe breaks SQL Server on Docker containers on Apple silicon

By

The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer...

Read the latest Blogs

Forums

Extract from sql.to multiple sheets

By Sqladmin1

Import-Module ImportExcel # Path to your .sql file $sqlFile = "C:\Data\MyQueries.sql" $excelPath = "C:\Data\SqlExtract_$(Get-Date...

sp_prepare and sp_execute vs sp_executesql

By rajemessage 14195

I have noticed sp_executesql also makes a single plan for a stmt with parameter...

Who am I?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Who am I?

Visit the forum

Question of the Day

Who am I?

If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?

create procedure AddNewCustomer
  @customername varchar(200)
AS
BEGIN
    DECLARE @added VARCHAR(100)
    SELECT @added = xxx

    IF @customername IS NOT NULL
      INSERT dbo.Customer
      (
          CustomerName,
          AddedBy 
      )
      VALUES
      (@customername, @added)
END

See possible answers