SQL Server Standard Edition only supports up to 2GB RAM per instance. SQL Enterprise edition can use more, but you must configure advanced options (or possibly AWE if >=...

There are many, many things that you can do to improve this procedure, and I'm sure you'll get a bunch of comments about all those things; however, the first thing...

You would want to insert the salaries into a temp table that has an identity field in it, inserting the values in the order you need, then select the row...

try this in your select:

(

CASE

WHEN LEFT(CAST(textdata AS VARCHAR(4)), 4) = 'exec' THEN

SUBSTRING(textdata, 6, CHARINDEX(' ', textdata) 

ELSE textdata 

END

) AS Query

Analyze the Execution plan for both the sproc and the statement in QA to see whre the differences are. Also, have you recompiled the sproc?

You can use the Errors Collection of the ADODB.Connection object to obtain error information returned from SQL Server. Be sure, however, that you stored procedures properly issue a RAISERROR...

You need to qualify the Sender field with the tablename it belongs to that you are searching on. SQL is complaining that it has found two tables in your...

Look for a non-fully-qualified field of Sender in your WHERE clause. The SELECTs look fine.

me 2

I guess this brings up the issue of why was PetCo even storing the credit card numbers in the first place...I've heard of some situations where the vendor would need...

My theory was that since the bitwise AND operator tells you whether or not "this bit pattern is a subset of that bit pattern", an index on the INT field...

You could consider creating a permanent table storing the max date for each account number (essentially making your derived table permanent). This would improve performance since tempdb would not...

Have you set up a valid DSN on the server for MS Jet 4.0?