Hi,

I also thinking of using Ian method but afraid it the job will hog the CPU resources.

Currently, some SP is causing high CPU usage, I don't want the agent to...

Hi,

Thank for the feedback. I know that we can just remove the syscomment

but there is still tool to reverse back the code, hence not safe.

Hi,

Since we are in the encryption issue, beside encrypting the data in the tables,

is there any way or tool to encrypt the stored procedures/triggers/function ?

I am looking for a free...

Hi,

First, my excel file consists of 3 sheets only.

When I use the opendatasource to import the excel file, it is causing

high CPU usage and resource use. The data is...

Hi Herring,

Below is my example to illustrate my issue.

From your article, I know how to use function to

update using select statement.

But I can't think on how to insert new values

using...

Hi Herring,

I read with interest on this topic of the 'replacing cursor and while loop'.

I faced the same problem on having lot of cursor which I replace with loop, but...

Hi,

Sorry if my objective is not clear. I am not a native English speaker.

Back to my question. I already have some DB with their views and SP not encrypted now.

I...

Hi,

I am also looking at encrypting all my existing stored procedure.

I am thinking of giving my remote office a script to encrypt current

SP that is not encrypted.

Have any one of...

Hi,

The main reason for not using SQL native referenical integrity is we need to help

user to import their data one stage at a time. We can't import all of them...

Hi,

Yes, I read on some articles that mentioned it will add extra administrative work

on the maintenance and backup/restore.

The growth is around 10-20G in 3-6 months time. I am afraid that...

Hi,

Thank everyone, someone point out that my problem and QA limitation.

One of my debugging tool, show that some of my input parameter is '',

so I enter '' for that parameter...

Hi,

Actually, my SP just having 02 cursor

where the outer cursor will pass some

info to the inner cursor to process

and update some data.

I have modify the outer cursor into

using loop...

Hi,

Thank a lot for your advise.

I have done all the above 03 commands but some of my SP calling some view still

are very very slow. It used to be fast...

Hi,

Thank

But why using 'sp_updatestat' actually slow down my SP ?

It should be helping to 'speed' up my SP instead

Hi,

Thank for the advise.

Actually, we are having some problem with our web application using SQL2k SP3.

We also helping our client migrate their legacy data to our system using C# written

application...