Viewing 15 posts - 1 through 15 (of 37 total)
I've finally tracked this down! I noticed my DBCC was taking ages on : dbcc ssb check
This is not terribly well documented but is a consistency check on sql...
January 10, 2011 at 3:12 am
I executed:
select name, * from sys.dm_db_index_physical_stats
(DB_ID(N'MyDbName'),null, null, null,null)
There was no size in KB in the result set of the query. I get a page_count though, that summed and...
July 15, 2010 at 5:55 am
I totalled the reserved size: 538,808 KB.
DBCC UPDATEUSAGE reported:
DBCC UPDATEUSAGE: counts updated for table 'sysobjvalues' (index 'clst', partition 1):
USED pages (LOB Data):...
July 15, 2010 at 4:25 am
I used this proc. In summary: It runs spaceused on all tables where OBJECTPROPERTY(id, N'IsUserTable') = 1:
DECLARE @TableName VARCHAR(100) --For storing values in the cursor
--Cursor...
July 15, 2010 at 4:13 am
Recreating the full publication + subscription has restored full functionality.
January 26, 2010 at 5:24 am
Ok, further investigation has resulted in a partial fix which I'm going to write up here so if anyone else experiences this they can try what I have done.
My symptoms...
January 22, 2010 at 2:36 am
Thanks for that!
I have just tried this. Replication Monitor is still broken but at least the procs don't need recompiling again...
January 22, 2010 at 1:41 am
Matt Wilhoite (11/11/2009)
Yeah that is odd. Have you checked the identity seed and increment? I am not sure what else would be causing that.
Seed and increment are 1...
November 11, 2009 at 9:11 am
Sorry, I just updated my post, I think we were posting at the same time!
As far as I am aware, rollbacks would not produce the behavior I am seeming:
I...
November 11, 2009 at 7:15 am
FYI, you can use server aliases to get around this issue
If I were to move this database to it's own server, which could happen if either of these databases or...
October 19, 2007 at 3:19 am
woops spoke too soon, here are the links
CLR solution:
http://blogs.sqlservercentral.com/blogs/amachanic/archive/2006/03/01/510.aspx
Cursor vs Set based:
http://blogs.sqlservercentral.com/blogs/amachanic/archive/2006/02/28/508.aspx
January 15, 2007 at 9:58 am
Adam Machanic posted a comparison of the performance on a 'running total' style problem. He compared set based, cursor and CLR proc solutions. The set based calculation performed...
January 15, 2007 at 9:54 am
I find the complete compare totally unusable. The Erwin data modelling tool has very little in the way of intuitive version control functions. It also has poor 'macro'...
December 12, 2006 at 6:40 am
Before you re-engineer any procs to use 'SET NOCOUNT ON', check your developers aren't using the built in optimistic concurrency checks in ADO.Net.
This requires 'SET NOCOUNT OFF' to...
December 12, 2006 at 4:36 am
Hi david,
I used to use VSS's client directly as you described. I have found that management studio saves a marginal amount of time as i don't have to...
December 4, 2006 at 4:37 am
Viewing 15 posts - 1 through 15 (of 37 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy