Viewing 15 posts - 16 through 30 (of 42 total)
Summary of what I have done so far:
DBCC CHECKDB --Found no errors
DBCC DBREINDEX --I think checkdb does this too but just wanted to cover everything.
DBCC UPDATEUSAGE --Ran after hours...
November 10, 2003 at 10:21 am
I have thought several times about having a backup dba but haven't proven to management the justification of such an expense...until I go on vacation. That is generally when...
November 7, 2003 at 9:32 am
Sure. I have found my linked server connection between our SQL db and an Oracle db on the WAN to be unreliable. Periodically, I just can't get a...
November 6, 2003 at 1:48 pm
When I wrote that I run update stats, dbcc updateusage is what I meant to say. Upon further investigation, it appears that some of my tables aren't getting re...
November 6, 2003 at 11:52 am
No Errors available in the logs. Both on SP3.
October 2, 2003 at 11:57 am
Perhaps SQL Profiler would allow you to see what steps are being performed and monitor it at that level. It wouldn't give you a percent complete or anything like...
October 2, 2003 at 11:20 am
Thanks for your responses. There is a standard query that will return all rows to the customers view. We will be allowing the customer to create their own...
August 21, 2003 at 9:37 am
One other thing...I have noticed that msmerge_tombstone on the publisher and subscriber have a different number of records. Is that normal...I would assume not.
June 18, 2003 at 7:42 pm
Nice work Andy. Running profiler led me to the sp_msupd sproc. The dist agent was passing the correct variables but my sproc was not running appropriately. This...
June 9, 2003 at 12:13 pm
Thanks for the response. Yes there are over 20,000 rows that have been updated for these columns. I have not run profiler. Thanks for the tip. ...
June 9, 2003 at 9:03 am
Before you decide on either Replication as your failover, please keep the following in mind:
It doesn't replicate jobs, alerts, default values, constraints, triggers, primary key definitions and a host of...
June 6, 2003 at 4:55 pm
Another bit of information:
Running DBCC SHOWFILESTATS
returns the results as used in Enterprise Manager. These statistics show the filegroup as being 6gb available and 4.3gb used. Anyone know what...
March 11, 2003 at 2:25 pm
There are some 3rd party tools but I'm not aware of any system info on this without re-writing the 3rd party software. SQL Compare can compare 2 db's to...
March 11, 2003 at 11:23 am
That was an interesting suggestion...thx. However, it appears there are indexes on the rowguid columns of these tables. Any other thoughts?
February 5, 2003 at 9:12 am
Viewing 15 posts - 16 through 30 (of 42 total)