Viewing 15 posts - 35,731 through 35,745 (of 49,557 total)
UPDATE STATISTICS dbo.[db_log_pt-BR]
November 19, 2009 at 1:07 pm
Do you have queries that filter on the combination of SSN + MyDataID or City + MyDataID?
p.s. That's a poor choice for a clustered index. See part 2 of this...
November 19, 2009 at 1:00 pm
Kwisatz78 (11/19/2009)
If so how do I resolve this?
Providing there is no existing transactional replication publication....
Create a new transactional replication publication.
Run sp_repldone in the published database
Drop the newly created publication.
Run...
November 19, 2009 at 12:58 pm
There's a discussion on whether a nonclustered index should explicitly contain the clustering key in the discussion for part 3 - http://www.sqlservercentral.com/Forums/Topic819337-1390-1.aspx
November 19, 2009 at 8:21 am
Maybe.
By primary key, do you mean clustered index? The pk is only clustered by default, it can be enforced by a nonclustered index. I'm going to assume you meant clustered...
November 19, 2009 at 8:17 am
Snapshot replication or transactional replication? Very important to know the difference.
Backup with truncate will do nothing for the bloated log if the problem is replication. It'll just break the log...
November 19, 2009 at 8:15 am
Depending who you read, recommendations for TempDB range from 0.25 files/core to 1 file/core. Regardless, the X files per Y cores is a standard recommendation for TempDB and is done...
November 19, 2009 at 7:55 am
jasona.work (11/19/2009)
November 19, 2009 at 7:29 am
What recovery model? Are you doing log backups? Is the replication log reader running? (check the replication monitor)
November 19, 2009 at 7:14 am
November 19, 2009 at 7:12 am
Take a look at the new system views. sysdatabases and many others that you would know from SQL 2000 are now deprecated and will be removed in a future version.
November 19, 2009 at 7:09 am
Johnc (11/19/2009)
We don't update the key column but rows can be deleted. Would this deletion be the cause of the fragmentation?
No. Deletes can't cause fragmentation. They can result in pages...
November 19, 2009 at 7:08 am
Viewing 15 posts - 35,731 through 35,745 (of 49,557 total)