Well actually yes, Foxpro is faster than SQL in many cases. This was originally due to the Rushmore technology that Fox Software developed, which was subsequently adopted by Microsoft...

Is your database automatically extending? Change the incrementation value to something much bigger, say 250Mb. This will reduce physical fragmentation.

As Steve says, this could be caused by a...

Simple:

CREATE PROCEDURE foo WITH ENCRYPTION

If you own the source code, then ask for it, otherwise, you're stuck.

Simon, UK

I have done a similar thing migrating Foxpro to t-SQL.

I assume you mean:

declare @Foo int

set @Foo=4

select case when @Foo>3 then 'more than 3' else...

The network is relevant because that is what you have. Each of those SAN devices is connected via a FC switch to your server(s). The speed of most...

You could also construct your query string in a separate variable, then just pass that to @query.

You ought to be talking to Microsoft directly about this. As you know, there are very few hardware vendors that can ship Datacenter Server. NEC comes to mind,...

You could put the table in its own database and set the Recovery option to Simple (in 2000); or set Truncate Log on Checkpoint (in 7 or earlier).

So long as...

Yes, Brian when are we going to see your review? Downloading the demo is not trivial, so your review is eagerly awaited.

Regards

Simon

Well I'll suggest that you're deleting rows from base.dbo.na_log which has an alias of B in the following query, but you're filtering on A.Update_Type?

Perhaps it's more subtle than this?

Regards

Simon

Hi Vijay

Could I ask a few questions on this:

Are you calling a stored procedure to extract your result set?, or is it a dynamic query? Are there parameters on...

As a thought, if you have an overnight process that needs one specific index to improve it, why not create the index within that stored procedure, or before it, then...

I think there is a contradiction here. On the one hand, you are saying OLTP, and then you're saying heavily indexed big tables. What do you mean by...

Have you altered any of the parameters in the SQL setup regarding dynamic allocations of memory? Can you tell us the CPU in the machine? Have you actually...

Apologies if this sounds flippant, but you're trying to run a memory hungry database server on a machine which is totally inadequate. I know from past experience of running...