I am aggree with you nothing guarantee that the plan will be there in the next call.

But i am not agree with you that for every sql query a plan...

I will try to use more closely related SQL Server terms:

Is it better to use (more efficient):

sp_executesql N'SELECT * FROM cust WHERE custId = "BOB"'

Or is it better to use:

Parameter markers are not limited to be used only with stored procs.

Here is an extract of what can be found in BOL about parameter markers:

"

Parameter markers are not limited to...

Thank's a lot Steve...

If I have time to experiment it I will post my observations here.

Have a nice weekend.

Carl

Thanks for your suggestions dcpeterson but we don't want to add an overhead.

I would have thought that a setting would have made it possible to modify this behavior at the database server level.

Best...

Ok thank's Frank,

Bye the way my english is not very good so the expression "Oracle world" should not be mis-interpreted.

Best regards,

Carl

Hello Steve,

In the SQL Server world '' is not NULL but in the Oracle world it is.

I try to find a way to make them behaves the same.

For us it is the rigth behavior...

Thank's for your replies Tymberwyld, all of this is related to the way our own database acces layer is implemented.

Best regards,

Carl

Our concern is not about the decrease of performance related to the numerous connection needed.

Our concern is more about locking issues: If I open SqlDataReader on one table because I...

Ok thank's Thomas.

Best regards,

Carl

Yes but how to tell the os to not recreate it each time the server restart?

Is it by just giving it an initial size and max size (equals)?

Thank's

Carl

How (and where) can it be set at the os level that the pagefile is not recreated each time the server restart?

Thanks

Carl

Thomas,

I wasn't aware of that:

"The reason is, the O/S will recreate the pagefile when it is restarted, or dynamically size according to needs. Many, many O/S operations use this file,...

Hello Listers,

Why don't let the paging file at its default value at my sens a server on which SQL Server is installed should not swap at all.

No?

Thank's

Carl

Yes we already have a primary key on that table. The primary key is on one column and this column is not in the list of the column involved in...