UPDATE STATISTICS dbo.[db_log_pt-BR]

Post the table definition

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...

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...

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

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...

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...

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...

jasona.work (11/19/2009)

---

I've been reading around, on "best (or recommended) practices" for SQL Server. One recommendation seems to be to have ".25 files per CPU core" for your DB. ...

What recovery model? Are you doing log backups? Is the replication log reader running? (check the replication monitor)

Please read through this - Managing Transaction Logs[/url]

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.

No. Deletes can't cause fragmentation. They can result in pages...

Spam. Reported

Sorry, don't understand the question.