It's definitely a security issue based on Windows, not SQL Server. This is the type of error you'd get with either of the security issues mentioned by Perry. check with...

What Perry and Gail are looking for is the actual command that might be failing. What you want to do is get the command working, and then work backwards, looking...

I'm with Grant here, look at hardware.

also, is this a new restore or restart? Could it be caching somewhere? If you run that query twice, is it the same speed...

First, please post in the appropriate forum and give your version. Moving this to 2005 admin.

Second, you need to check the SQL server logs and look for the reason that...

5 days is plenty. Sorry, missed the OP date.

I'm interested to see the benchmarks. I know doing this in C would be complicated, but not tremendously more than a search...

Give him or her time, might be on the other side of the world.

If you compare REVERSE with SUBSTRING or other string functions, how much slower is it? Any benchmarks?

Well we have 4 horses, and while they go up the hill easily, it's the picking up behind them that's not much fun 😛

But be sure that you know if you need a low fill factor. This is the percentage of space on the pages that are filled. If you are really growing...

Phil,

A fantastic last sentence and a great editorial. I too am not sure that we can build a great code checker for SQL, but there are definitely some basics that...

or just R (read)

OK, my head hurts.

I've awarded back points since there is obviously some issue here. I missed the correct answer with 1/30, so I've fixed that.

As far as the other items,...

Look also at RESTORE FILELISTONLY

Doh! Good catch and glad it's working.

The thing you could have done is set a very low fill factor and there would be lots of free space on pages, but as you changed data or added...

There are also numerous scripts here on this site for backups that you can go through, see how they work, experiment, etc.