Viewing 15 posts - 25,246 through 25,260 (of 39,921 total)
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...
February 18, 2009 at 7:15 am
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...
February 18, 2009 at 7:13 am
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...
February 18, 2009 at 7:11 am
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...
February 18, 2009 at 7:10 am
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...
February 18, 2009 at 7:07 am
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?
February 17, 2009 at 9:15 pm
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 😛
February 17, 2009 at 2:36 pm
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...
February 17, 2009 at 2:36 pm
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...
February 17, 2009 at 2:36 pm
Look also at RESTORE FILELISTONLY
February 17, 2009 at 7:28 am
Doh! Good catch and glad it's working.
February 17, 2009 at 6:58 am
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...
February 16, 2009 at 10:09 pm
There are also numerous scripts here on this site for backups that you can go through, see how they work, experiment, etc.
February 16, 2009 at 10:06 pm
Viewing 15 posts - 25,246 through 25,260 (of 39,921 total)