Scott's point about SQL having to assume that there could be 2000 chars of data even if there might only be 20 typically is also evident from the warning message...

Thanks for sharing the results of your experiments - it's nice to see feedback appear on the forums.  Hopefully when someone else has the same question they'll at least be...

Naughty me - I had meant to say that logs are on RAID 1.  TempDB can be on RAID 0.  Thanks for pointing out mistake!

It's seamless - you can specify multiple files for SQL Server to use for storage.  When creating tables & indices you can specify on which file the table/index is created.

It...

You could create a covering index on the columns used by the UDF and have the ordered column as the first in the index - this would at least speed...

You probably have one or more indexed views or indexed computed columns in your DB - these require particular "set" options.  Look in SQL Server books online to see what these...

One of your examples is...

select  DOSFrom,DOSTo

From ExpenseHeader (NoLock)

Join ExpenseDetail (nolock) on pkExpenseHeader = fkExpenseHeader

and pkExpenseHeader =  677067

You should also try looking at

select  DOSFrom,DOSTo

From ExpenseHeader (NoLock)

Join ExpenseDetail (nolock) on fkExpenseHeader = 677067

and pkExpenseHeader =  677067

Again,...

Could you please post the code and some example data?  I cannot think of a way to determine which row is causing the problem apart from recoding as a procedural...

Very true.  I guess SQL needs some standard way to handle the NULLs, Arithmetic Overflows, when materializing the index, scanning the index, etc.

Are you posting code with < & > in it?  Perhaps try uploading it somewhere as a text file and linking to it if it won't post to SQL Server...

Hi - please post the code and we'll have a look.  You have several issues

1. Passing multiple data values to a stored proc from ASP - Ryan's link above should...

A common misconception is people thinking that SQL Server works similarly to file-system based databases such as FoxPro/DBase which have the concept of row numbers and traversing a table in...

Hey no apologies needed - common mistake that everyone makes.  Fortunately no one has called me Mr or Mrs 500 yet

That's a...

Thanks for the update.  Nice to know what others in the real world are doing.  I agree - database mirroring (I haven't had a chance to use it yet) seems...

Couple of thoughts...

1. Homebrew01's name is not addict   Merely that he/she has posted 436 times giving the "rank" of addict.

2. Real thoughts...  It...