Yes, it does mean that. If that's going to be a problem for you, consider taking differential backups. These backup every page (or maybe extent) that has been...

You have to restore all log backups in the chain, not just the most recent. So if you want to bring the database to the latest point possible using...

If you want to see everything from #tmpOperationalTypes, you need to put it on the left hand side of your LEFT JOIN (or change the LEFT JOIN to a RIGHT...

What do you mean by "rows with no data"? Please will you provide some examples?

John

Could it be the double-hop issue?

John

Don't do this. It just wastes resources and causes fragmentation. If your log files are getting large, then back up your transaction log more frequently. Bear in...

What you're seeing is a cardinality error, and it's why you should be careful when using the UPDATE...FROM syntax. It occurs when the value you're updating in table a...

Search for "managing transaction logs". There's loads of stuff out there.

To add...

BWFC (6/18/2014)

---

I disagree there. It doesn't say that all on site databases are 2012, it says that uses 2012. That doesn't preclude there being 2000...

Precisely. All on-site databases are 2012, meaning 2000 can't be the answer. And since an Azure...

Well, the best way to find out is to try it!

John

IF NOT EXISTS (

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

WHERE COLUMN_NAME = 'USA_RFORIGEM '

AND TABLE_NAME = 'CONFIGURACAO'

)

ALTER...

Sean Lange (6/16/2014)

---

It is only a game but at the level we are talking about it has serious financial implications to the nations involved. I too really dislike the attitude...

Yes, he has had some pretty barmy ideas in the past,...

You can set up your own auditing on your database, for example using triggers to write to audit tables whenever any changes are made to data in any tables. ...