Viewing 9 posts - 1 through 9 (of 9 total)
Your MMC may start crashing while attempting to do certain things,like trying to expand Subscriptions, etc.
November 16, 2004 at 12:05 pm
Check the errorlog in LOG subdirectory of the original installation location. You may have to run setup.
November 16, 2004 at 11:44 am
DBCC statements should have taken care of clearing out the old plan from the cache.
As per placement, of course you want to put DATA device on a separate RAID-5 array...
October 19, 2004 at 11:27 am
We've had a very similar situation where QA produced a fast response while intranet site "SOMETIMES" was timing out while still holding shared locks on the tables involved. sp_recompile did...
October 18, 2004 at 4:45 pm
1.
RESTORE DATABASE database_name WITH RECOVERY
EXEC SP_DBOPTION 'database_name', 'read only', 'false'
EXEC SP_DBOPTION 'database_name', 'dbo use only', 'false'
2. Search for sp_help_revlogins
October 18, 2004 at 4:29 pm
I would question this approach in designing an app. Are you looking for disaster or just experimenting? Even after you're done with your app (doubt it) you're still liable directly...
October 18, 2004 at 4:20 pm
It's not just SQLCompare, it's a bundle that includes SQLCompare, SQLDataCompare, DTSCompare, and possibly SQLPackager (not sure on the last one). I think Red-Gate will give you the best bang...
October 18, 2004 at 2:33 pm
If the table does not have any foreign keys, - BCP data OUT by creating a view with TOP 100 PERCENT and ORDER BY the field that you'll use for...
October 18, 2004 at 2:23 pm
Since the waittype was Share (0x3) then while adding 30GB worth of data there was quite a bit of lookup operations.
October 18, 2004 at 2:19 pm
Viewing 9 posts - 1 through 9 (of 9 total)