De Quervain's tenosynovitis -- is the surgery effective?

Yes. If injection of steroids and bracing has not made sidnigicant improvement then the surgical release of the tendon pully is very helpful in pain relief.