Well, yes, but consistenly high IO is going to lead to higher overall cache turnover (i.e. pages needed by other processes aren't going to stay in memory as long as...

They're LOGICAL reads and writes - you can't infer whether or not they're coming from disk or memory.

If the duration is also high, this is a good indicator that they're...

When you design a database, always think whether you might need an archive database or not.

If your database will store data for a long time, and if that data can...

Carl, this isn't uncommon with 3rd-party apps.

You need to ensure that the load program always runs from the same account, otherwise you are going to create multiple copies of...

If you're using SQL2000 SE, you can't use AWE and so cannot allocate more than 2Gb of memory.

Try this link:

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

Try using sp_MSforeachdb (be aware, it is undocumented).

More information here: http://www.transactsql.com/html/sp_MSforeachdb.html

Hmm. I see - I thought Juanita was actually trying to remove the time portion altogether, not just set it to 0.

I'd write this using dynamic SQL.

DECLARE @sql = nvarchar(4000)

SET @sql = 'Select * from test Where PERIOD = ''curr_mon'''

IF @CUSTOMER is not null

SET @sql...

At the risk of flogging a point to death here, but I do think it's of interest, I've adopted the "test" approach and come up with some results. See...

Can't argue with the "test, test, test" doctrine. I've put a request in to my line manager to attend the Reading seminar, too!

Colin - I'm intrigued about your comment on the subject of column order. Since the only SARG column is on CatID, if this wasn't the leading column in the...

That doesn't actually strip off the time portion though, or am I missing something?

Colin's right - a covered index would give the best performance here (although I think it should be on [CatID, ItemID, Name], since CatID is the column in the Search...

Gabriel,

David may well be right (I'm not too good on the various connection property differences between clients that might affecte performance either), but if you could post some sample code...

John,

I'm not sure that you're actually going to be able to achieve what you want with only 3Gb available.

The /3Gb parameter needs to be placed in the Windows boot.ini...