Archives for sql server

Create the tpc-h database schema for SQL Server

Last time we created some test data with the tpc-h tool. This time i just want to post a short t-sql to create the database schema.

Read More

Create test data with tpc-h for i.e. SQL Server or MongoDB

When you are testing databases (i.e. Microsoft SQL Server or MongoDB) or ETL-tools (like Pentaho or SSIS) you often need great amounts of data. The tool tpc-h from the „Transaction Processing Perfomance Council“ fits this needs and generates as much data as you need.  This should be a short tutorial how to compile the tool an generate some data.

Read More