Turning the checksum option on does nothing at that point. Only when the page is next written out will the checksum be added. Rebuilding all indexes is the best way...

Thanks everyone

I did have more posts than...

The reason is in the error log

Operating system...

Nested replace will do that.

REPLACE(REPLACE(SourceString,'Brigade Army','BAY'),'Brigades Armies','BAY')

That one is quite misleading and has no discussion of the considerations or requirements. I'd avoid it.

cw18 (12/6/2013)

---

I would try;

select distinct top 100

i.invoice_id, i.buyer_code, i.submit_time, i.request_id

from

dbo.invoice i

inner join dbo.invoice_adj ia on i.invoice_id = ia.invoice_id and ia.amount !=0

left outer join dbo.invoice_detail iad on i.invoice_id =...

kevaburg (12/6/2013)

---

Grant Fritchey (12/2/2013)

---

When you run a full backup, it also backs up the transaction log. If your transaction log has 30gb of transactions that have not been backed up...

Please note: 3 year old thread.

That's the easiest

there is some other simpler way out for data refresh using backuped data...

If you're trying to get queries running faster, don't waste your time looking at partitioning, it's not a general performance tuning technique. Performance improvements are possible from partitioning, but it...

No

When do I rename...

Easier way. Take a backup, copy the backup to the destination, restore the backup.

The Copy Database option can be a little finicky at times.

What do you mean by 'collocation'? The definition I'm familiar with is 'the action of placing things side by side or in position', which doesn't make sense here.

As for the...

Ideas can't be copyrighted.

I have an idea for an article on when and how to create multiple file groups

I have an idea for an article on backups types and restores.

I...

dan-572483 (12/5/2013)

---

What I figured out was that appearently if you need to relocate a log file and the database is using Simple Recovery Model, you don't need to move the...