Viewing 15 posts - 76 through 90 (of 295 total)
also ran this command. It got executed in few secs but the size of the tables doesn't seem to go away.
ALTER DATABASE db_name SET ENABLE_BROKER with rollback immediate
December 3, 2014 at 6:54 pm
Also, I ran ALTER DATABASE msdb SET NEW_BROKER...its been running for 30 mins now.....Any idea why is so?
December 3, 2014 at 6:40 pm
The database in question is different db. Not MSDB. So I need to still run that for MSDB?
December 3, 2014 at 3:46 pm
I ran the following on the db. And It shows 88 GB is reserved by sysxmitqueue. Do I need to worry about this? If so, how do I get rid...
December 3, 2014 at 2:38 pm
About 40 internal objects that spans on 417 pages. How do I go about getting their sizes?
December 3, 2014 at 10:55 am
what else should I look for? Need to know what is other 100GB comprise of?
December 3, 2014 at 10:23 am
My XML looks like this and can't decipher. I do get the the object id to tell me which table. But can't tell for sure what query was running at...
October 7, 2014 at 3:38 pm
Thanks. How do I see the query that was run to cause the deadlock?
October 6, 2014 at 3:31 pm
how can we modify this to keep today's record but delete previous entries?
June 12, 2014 at 2:35 pm
Does it leave today's data in there or delete those as well?
June 12, 2014 at 1:01 pm
Viewing 15 posts - 76 through 90 (of 295 total)