I am not rabidly against SPs (I did say performance might be significant), but I am really interested in whether you other guys' have used SPs extensively for absorbing a...

At a selection-ration of 2.5%, the optimum access method is hard to decide, for the optimiser and for a developer. If you were selecting a continuous range from a...

If you are looking at PhysicalDisk, I think you might have to switch them on with a command (and reboot):

DISKPERF -Y

http://www.sql-server-performance.com/sg_sql_server_performance_article.asp

Would "InvoerDatumTijd" have the same value for every row in the batch ? I have seen high-ratio keys cause problems in other databases, but I thought SQLServer handled it,...

Depends.

Depends on the SQL client - it might choose to retrieve all rows in one hit, but it sounds like your example did not.

Depends on how the opimiser executes the...

The arguments in favour of stored procedures are mainly:

- Performance - pre-optimised query plans and smaller command text ?

- Expertise - an SQL expert can do the queries

- Re-use -...

You can pretty easily create a SQLAgent Job that checks a directory every 5 mins. Use sp_filexists @filepath, @exists OUTPUT /* exists integer */

Then you can rename...

This is a favourite topic of mine.

The compiler/optimiser isnt smart enough to trace your assignements. It doesnt know that @FromDate_LU is derived from @FromDate when it optimises the query....

In ADO, Print text appears in the Errors collection:

DBConn.Errors(n).Description

There might be difficulties with timing - they might only appear after the recordset (all recordsets?) is fully retrieved.

Given your table is named FRUIT does that mean Pears are only one of many types ?

If so, I suspect the problem would be that most fruit do not have...

Given the data cannot change then in theory there is no reason to update statistics. I suppose you could imagine Auto-adding working to better optimise query plans, but I...

I have seen SQL2000 problem with comparisons between Unicode (Nvarchar) and regular varchar after conversion from 7 (they did implicit conversion the opposite way).

Another one might be Collation - default...

article: sqlservercentral

I have qualms about it:

* Could be fallible with concurrent processes.

* Can you really limit the errors you want to trap to a subset ?- otherwise you log...

What about sp_ExecuteSql.

It can pass values BACK out of dynamic statement by binding variables inside the dynamic statement to variables in the calling context. Something like:

declare @parm1 integer

set @parm1...

Maybe you have special characters in @msg, especially ">" or "|", also "&&".