Importing JSON file in MongoDB

Situation You have a JSON file or CSV file and you want to import into a MongoDB database. How can you execute this task? Solution MongoDB provided a tool that named as mongoimport that can help us to import a data set into a Mongo database. For understanding mongoimport , click here In my example, I tried … Continue reading Importing JSON file in MongoDB

Advertisements

How to create a partitioned table in SQL Server

Problem When you work on SQL 2000 or some higher version but not Enterprise edition, you often encounter the difficulty for creating table partitioning.  You often create some base tables such as Sales2007, Sales2008,... to store yearly data and then create a view to query those data. This approach is sometime called physical partitioned table … Continue reading How to create a partitioned table in SQL Server