Viewing 15 posts - 39,046 through 39,060 (of 49,571 total)
Then make sure that you have good indexes that support the queries that are being run. If you're not sure what constitutes a good index for a query, post the...
May 19, 2009 at 5:29 am
dakshinamurthy (5/18/2009)
May 18, 2009 at 11:40 pm
May 18, 2009 at 11:34 pm
It's got nothing to do with compat mode.
If you're seeing repeated cases where you run UpdateUsage, the error goes away and then later comes back, and you're on SQL 2005...
May 18, 2009 at 3:48 pm
amina omar (1/23/2004)
My transaction log keeps filling up, even though it's backup nightly and should be getting truncated any time it's backed up.
Transaction log backups or database backups? Only tran...
May 18, 2009 at 2:18 pm
pradyothana (5/18/2009)
If there is no logshpping in place, Better to truncate the log after backup.
That is terrible advice to give, especially since you don't mention what truncate only does and...
May 18, 2009 at 2:02 pm
The error was probably a left-over from SQL 2000. If you get it again, after you've fixed it with UpdateUsage, then maybe consider calling product support.
May 18, 2009 at 1:54 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic718937-338-1.aspx
May 18, 2009 at 10:23 am
karthikeyan (5/18/2009)
Using this only backup file how can i restore.
You can't.
You have one piece of a backup. If three backup destinations are specified (either in script or in the...
May 18, 2009 at 10:20 am
monsieurmark777 (5/18/2009)
Have checked the DBs and they all seem to be set as "French_CI_AS"...Any clue why I can't append your line?
Check the server's collation (which affects the system databases), check...
May 18, 2009 at 10:14 am
DNA (5/18/2009)
You can reorganize the database using a maintenance plan or by shrinking the database in Enterprise Manager/Management Studio.
However note that shrinking will badly fragment all indexes and...
May 18, 2009 at 10:13 am
sk.panda (5/18/2009)
Could you please suggest me what are the best possible way we can optimize the table so that we can improve the performance our application using this table?
Good indexes...
May 18, 2009 at 7:12 am
george sibbald (5/18/2009)
Gail, stop it! give someone else a chance! 😀
Type faster in future. 😉
😛
May 18, 2009 at 6:34 am
Index fragmentation and disk fragmentation are different things. Indexrebuild and index defrag (and the 2 SQL 2005 replacements to them) fix index fragmentation. They are neither affected by nor do...
May 18, 2009 at 6:29 am
jensgc (5/18/2009)
May 18, 2009 at 6:23 am
Viewing 15 posts - 39,046 through 39,060 (of 49,571 total)