For sure, if only to protect the system from my own stupidity....

I agree that limiting the application rights will aid in the integrety of the system but I think the greater risk is an admin mistakenly dragging a file/folder into another...

I have been watching this thread with great interest because of my application.  In my case I have been working on this application on and off for the past four...

http://www.microsoft.com/resources/documentation/windows/2000/professional/reskit/en-us/part3/proch17.mspx

Shows that NTFS can hold 4,294,967,295 (~4.3 Billion) per volume.  I have a image archive database that currently has well over 200,000 images stored on an NTFS file...

I am not sure if this helps, I have had some problems with deadlocks in a database that I am working on and I got all the information I needed...

I have changed the query to read as follows, performance seems to be the same.

SELECT tDocArchive.arcuid, tOCRTokens.oct_token

FROM tOCRTokens

INNER JOIN tDocOCRTokens ON tDocOCRTokens.ocd_octuid = tOCRTokens.octuid

INNER JOIN tDocArchive ON (tDocArchive.doa_batchorder%1 <...

I would agree that the index seek is the most significant difference between the two queries.  The tDocOcrTokens table has the greatest number of rows of any table in the database, over...

Oops, I guess that would help

With: tDocArchive.doa_batchorder%1 < 1

  |--Sort(ORDER BY: ([tDocArchive].[doa_batchorder] ASC))

       |--Merge Join(Inner Join, MERGE: ([tOCRTokens].[octuid])=([tDocOCRTokens].[ocd_octuid]), RESIDUAL: ([tOCRTokens].[octuid]=[tDocOCRTokens].[ocd_octuid]))

            |--Index Scan(OBJECT: ([SecureDocs_v1].[dbo].[tOCRTokens].[pk_tOCRTokens]),...

I am not attempting to filter with that filter, I only noticed that the query runs faster.  Here is the plan you requested.

  |--Sort(ORDER BY: ([tDocArchive].[doa_batchorder] ASC))

       |--Merge Join(Inner Join,...

I get the same number of rows, the results are the same.