Home »
Archive by categoryDatabase
Running mongodb by command is easy but we required always to open command and run mongod and remain open it side by side while working on mongodb. In windows to run mongodb server automatically we need to install mongodb server as windows service. To install mongodb as windows...
Continue reading
August 21, 2016 Manoj
Database
No Comment
Given query return all table name with column which contain Search string. Following Query create temporary table with name #Results . and at last table is Dropped. If any error occurred during execution #result may not drop so be sure at last that Temp table #Results is dropped...
Continue reading
April 29, 2016 Manoj
Database
No Comment
To get result from table under hierarchy.
Continue reading
April 8, 2016 Manoj
Database
No Comment
To find Size of each table of database in sql server. Query use System table to get table name and allocation_units table to get total no of pages for each table. It give result as below for sample database
Continue reading
March 31, 2016 Manoj
Database, Databse
No Comment
RDBMS Vs MongoDB RDBMS MongoDB Database Database Table Collection Tuple/Row Document column Field Table Join Embedded Documents Primary Key Primary Key (Default key _id provided by mongodb itself) Change Databse use DATABASE_NAME Show Database show dbs Drop Database Switch Database then run Code db.dropDatabase() Create Collection db.createCollection(name, options)...
Continue reading
January 4, 2016 Manoj
Database
No Comment
There are several hosting provider capable of host mongodb database. I like mongolab.com and is very nice ,free and Fully managed. It give 500MB Space for free. Web-based admin tools. Management of any cloud MongoDB. DB to API 🙂 which i like most.For detail about mongo data to...
Continue reading
January 1, 2016 Manoj
Database
No Comment
Continue reading
February 18, 2014 Manoj
Database
No Comment
Manoj