I'll run again sp_configure tomorrow morning.

The memory usage is very high even in the Perf Mon. The machine is all pegged - the installer from my app cannot complete as...

No this will not work for me... The SP will be called from a cmd script among a lot of other stuff, which somebody else writes...still no idea what's inside....

I have similar problem:

I have 1 procedure which I/users will run from the QA, but I need to execute it simultaneously with different params - just to save time...

If I...

Thanks a lot, but is there a way to select the index code/ all columns which the index is build upon. These way before to drop it, I could have...

Never mind - I fix it - hate quates - don't you too?

Here is the correct script if somebody wants to use it:

-- DECLARE user input variables

DECLARE @tablename varchar(100)

DECLARE @Old_id_name...

Thanks a lot, guys.

What kind of script I can run to to check WMI?

Is there a place to see an example?

Thanks again, mj

Thanks for correcting me - this will be definately the safer way.

I'll try it this weekend on a middle table of 50 mln and I'll post my results on Monday.

If...

There's no DB objects in the application so it'll be db independant... The same code runs on Db2, Oracle, SQL server, etc...

OK, I found the way - why nobody advised...

I know I can get somebody's else inserted identity - this is fine...

My problem is that I'm not allow to make more then 5 calls to the database - if...

I do not appreciate such replays - we do not need to waist our time and the forum resources.

Thanks.

Thanks a lot. I just was wondering if I could optimize the insert/update showing this lock.

There is an error in Bulgarian months - for april - needs to be corrected - well, I do not have a cirilic right now and I cannot write it...

OK, but this doesn't work the way I need it:

it groups by seconds not by minutes...

How can I make it group by minutes?

Thanks,mj

Thanks a lot, guys, you saved me so much time.

There's nothing wrong with the execution plan. it shows that the indexes are in use and the cost is pretty good.

But when you monitor with the monitoring toll - even...