I haven't used Access in a while, so please forgive if the directions aren't 100%.  This is for Access 2003; Access 2000 is similar, but the menu options might be...

Like alzdba says, yes you can move all of your nonclustered indexes to a new filegroup on a different drive.  You can't do this with clustered indexes though.  Just create...

You say you put the NOLOCK hint on all the tables in your views right?

Hmmm how about something like:

DECLARE @i INT

SELECT TOP 1 @i = clustered_index_column FROM mytable

IF @i IS NOT NULL

BEGIN

    RAISERROR ...

END

Assumes your clustered_index_column is non-nullable of course.

1) srv_sendmsg just sends a text message (no color) to SQL Server.  You can send use the SRV_MSG_ERROR msgtype, set the class > 10 and the state (0 - 255)...

Just throwing out ideas...  that's what troubleshooting is about

Not familiar with your specific jobs, but I had a similar problem a long time ago with other installed software (antivirus software) kicking off updates and nightly scans that conflicted...

The "freezing" is probably due to the way Access processes queries   The Jet DB engine will grab everything from SQL Server and process...

Good advice, but I always go for the "cheapest" solution first...  Have you rebuilt indexes and updated statistics lately?

If you wanted to physically separate the database files, you might consider...

The main consideration for performance is separating out the main filegroups.  For best performance data, logs and nonclustered indexes should be physically separated from one another.

RAID 10 offers mirroring and...

Where ya been?

http://www.sqlservercentral.com/columnists/mcoles/sql2000dbatoolkitpart1.asp

OK, now that I think about it, xp_dirscan also relies on a few other libraries from the STL.  It may be having a hard time locating those libraries.

I posted the...

You can also add "complex logic" to your computed columns via CASE expressions.  This might offer performance benefits over a UDF.

Just as a really simple example:

May 9, 2006 at 8:01 am