The views alone are probably not the perfomance culprit. More than likely it is the nested cursors that are fed by the views. As for what to do about it,...

I hate to say it again, but shame on the healthcare provider again ... HIPAA covers just what had happened to them <period>  It is unfortunate that the employees were...

Backdoors or not the engineer is not totally to blame. The healthcare provider will be paying for their misfeasance with regard to HIPPA for a minimum of 3 years. This...

How are you getting the file frm the Unix server to your SQL Server ? The reason I ask is that may be the solution to your issue. I have...

EOJRR1, while a workaround for your packed decimal issue has been provided the 'root' cause still remains. It is generally accepted that when transferring data between disimilar operating systems (IBM...

I first encountered Sybase IQ when it was v11.5 at a Sybase Techwave conference - I believe that MS/SQL version I was working with then was v6.0 or v6.5. At...

Shame on the network engineer ... he deserves what he gets.

Shame on the healthcare provider for not changing their VPN setups and passwords after the network engineer was terminated -...

The wierdest problem I ever encountered was with the Agent in v6.0. We came in to work after the new year and no scheduled jobs had executed since December 31st....

Thank you noeld ...

Shoot me now - I like it !

Well it all depends ... on a lot of SAN related 'stuff' ... first the assumptions:

• You have dual HBAs - minimum 2 Gb (the 4Gb HBA are out now too)
• You...

I believe that you have a major architectural issue to solve first. That many connections in such a short amount of time ??? Are there not multiple application/web servers accessing...

"Any product that has over 500+ configuration parameters has a definite arcitectural flaw" - a 'true' statement from a Sybase DBA that I know when talking about Oracle ...

Granted Oracle...

How big is the data portion ?

Out of curiosity noeld just how many is too many ?