August 2012 – Database Consultant

What is MongoDB

A document specialized database-engine that uses a human readable subset of javascript – called json – rather than xml.

Listing disabled triggers

--disabled_triggers.sql
select name disabled_triggers
from dbo.sysobjects
where objectproperty (id, 'ExecIsTriggerDisabled') = 1

What about table joins in MongoDB?

er no … sorry. You can always join tables at the application level after uploading them – or just make a new table with the rows you need from other tables.

Joining sharded data would be very slow.

MongoDB indexing

Only uses primary indexes/ keys. No need for foreign-keys if there are no relationships.

If you need a table indexed on another column – make a copy of the table – indexed on the other column.