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