So do I.

But my customers want it so we are delivering SAP.

On any kind of platform, on any kind of DB as we are an outsourcing company.

But our preference is...

Na ja.

As you may know within SAP the real bottleneck is not the database server but the application servers.

But our overall SAP response times are quite nice: below 0,5 sec...

Already done.

This is a Microsoft "feature" they told to me.

And really it is not at all an SQL issue.

Try to have a database with several hundreds or thousends of tables...

It could be anywhere.

The only problem I actually have is that the file server where the input files are located are not in the same network segment as the DB...

I would.

But as of today there is no other tool where I can program quickly, produce a single .exe file, and having that .exe running fast on every 32...

The easiest way is to define a @FromDate and a @ToDate parameter in your proc so you have solved your problem.

Of cours you will have to define in your frontend...

As far as I know the only possibility you have is to build up dinamically your query within the proc. Of cours doing so you will lose the optimization made...

Jeremy,

Unfortunatly it did not help.

I've created a test database with 10.000 tables each with 1 clustered and 1 nonclustered index.

After my creation the system tables (sysobjects, sysindexes, syscolumns) became wery...

Frank,

Unfortunatly this is not the point.

Of cours I can call system command out of Delphi.

But what I have to do is programatically send the data to SQLServer (i.e via bcp_sendrow)...

By the way Tom,

The officiel answer from MS is that there is no official answer to my question.

There is a workaround which is copy the database with DTS which will...

The SP somehow do not want to fire.

I am in the test database.

I have the foolowing error message : "The database name provided 'test' must be the current database when...

Do you have the same amount of data on your test and prod machines?

The query plan shows a lot of table scans of the table TLNReferences (a clusterd index scan...

Si Chan,

I would opt for the Fastt600.

First of all that one is a Fiber Channel (FC) attached device, and as I see it will be a 2 GB FC interface....

Hey gurus,

No hints, no ideas?

I would really need a solution

An SP is basically no more then a compiled set of TSQL commands. If you put those commends into an SP and you just call the SP name from your...