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...
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...
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. ...
July 23, 2007 at 5:41 pm
I think this should work in both 2000 and 2005.
select
name, objectproperty(id, 'ExecIsStartup'
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...
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%...
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...
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...
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...
July 17, 2007 at 2:36 pm
This reindexes anything with fragmentation over 10%.
set
nocount on
declare
@command varchar(1000)
declare
...
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.
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.
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. ...
July 13, 2007 at 2:24 pm
Run an sp_help on CaseNum and post the results here.
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...
July 12, 2007 at 11:24 am
Viewing 15 posts - 46 through 60 (of 81 total)