Viewing 15 posts - 46 through 60 (of 81 total)
Bhavin,
If you took the time to run sp_help, take the time to post the results. As indicated by the error message you submitted, it *could* be an issue with computed...
Regards,
Rubes
July 24, 2007 at 9:29 pm
Why not just log on to the console and physically copy it?
I'm a little puzzled on what actually happened. How did the log file get to a different location to...
Regards,
Rubes
July 24, 2007 at 2:17 pm
Interesting. I just ran across this issue today.
We had a 3rd party backup application installed. It was running under an account that had select permissions on sys.databases but not sys.sysaltfiles. ...
Regards,
Rubes
July 23, 2007 at 5:41 pm
I think this should work in both 2000 and 2005.
select
name, objectproperty(id, 'ExecIsStartup' Regards,
Rubes
July 23, 2007 at 3:19 pm
Yes, I think you get it.
I think fillfactor is one of those areas where you can definitely answer with "it depends". Low fillfactors avoid page splits and fragmentation. Higher fillfactors take up less...
Regards,
Rubes
July 23, 2007 at 3:11 pm
Billy,
I think your question is... "Under what circumstances should a table have different fillfactors for different indexes?" For example, 100% FF on primary key pkid, 90% FF on FirstName, 50%...
Regards,
Rubes
July 23, 2007 at 2:34 pm
Jim,
There may be nothing wrong with your database or any of its objects. Instead, it may be that the application code is real buggy.
Your comment that the app throws...
Regards,
Rubes
July 23, 2007 at 11:58 am
Hmmm... I did some testing and found some interesting behavior. My conclusion is...
In 2000, the ORDER BY field is verified against all fields in all tables in the FROM clause. It...
Regards,
Rubes
July 18, 2007 at 1:40 pm
Any change in performance since the original post? Is it still slow?... and if not how long did it take to recover?
Also, what are the specs on the system, including...
Regards,
Rubes
July 17, 2007 at 2:36 pm
This reindexes anything with fragmentation over 10%.
set
nocount on
declare
@command varchar(1000)
declare
...
Regards,
Rubes
July 16, 2007 at 8:53 am
Not to beat a dead horse, but I have had the same issue as well. For that reason I've stuck to a reindexing script using DBCC SHOWCONTIG.
Regards,
Rubes
July 14, 2007 at 8:13 am
Your question is a little vague. You can do a restore over an existing database. Check out books online for RESTORE DATABASE.
Regards,
Rubes
July 13, 2007 at 9:54 pm
I am assuming that you are running SQL 2005. See http://support.microsoft.com/kb/917828. There are certain operations in 2005 that clear the procedure cache. Dropping a database is one of them. ...
Regards,
Rubes
July 13, 2007 at 2:24 pm
Run an sp_help on CaseNum and post the results here.
Regards,
Rubes
July 12, 2007 at 11:53 am
Based upon the error, I would look at the CaseNum table. Is it actually an indexed view instead of a table? Does an indexed view reference the table? Are there computed columns...
Regards,
Rubes
July 12, 2007 at 11:24 am
Viewing 15 posts - 46 through 60 (of 81 total)