Creating Complex Test Databases - Generating One Table for each of the 2,397 supported Collations

As a follow up to my series on complex test databases, this article will cover one of the more interesting test databases that I recently created.    Goal:  Create a database that includes one table for each supported collation.  Each table contains a single column with the various column level collations supported by SQL Server 2012 (nearly…

0

Creating Complex Test Databases - Using Excel to convert a raw list of text into viable T-SQL syntax

As part of my series on creating databases with interesting characteristics for testing purposes, I have covered a few different engine constructs, test strategies, and scripting techniques to build interesting databases.  In this article, I am going to highlight one technique I use fairly often with leveraging Excel’s text concatenation functionality to generate T-SQL script…

4

Creating Complex Test Databases - Creating a Table with more than 1,024 Columns

As part of my series on creating databases with interesting characteristics for testing purposes, today we’ll cover a question that was asked in the SQL Server MSDN forums regarding column limits.  The question is “What is the true column limit in SQL Server?” From a testing perspective, one of the more interesting documentation articles is…

0

Creating Complex Test Databases - Request for Ideas

Over the past week, I’ve written a few entries regarding complex databases with interesting characteristics for testing purposes.  Creating Complex Test Databases – Intro  Creating Complex Test Databases – Creating a Database with 1 Billion Random Rows  Creating Complex Test Databases – Generating One Table for each of the 2,397 supported Collations  Creating Complex Test…

1

Creating Complex Test Databases - Creating a Table with all Supported SQL Server Data Types

As part of my series on creating databases with interesting characteristics for testing purposes, today we’ll leverage the internal SQL Server system tables to create a table containing columns of each nullable and non-nullable data types supported by SQL Server. Goal:  Create a table that contains one column of every nullable data type and one column for…

1

Creating Complex Test Databases - Creating a Database with 1 Billion Random Rows

As part of my series on creating databases with interesting characteristics for testing purposes, today we’ll create a database containing a large number of tables, each with a large number of rows inserted. Goal:  Create a database with ONE BILLION ROWS.  The database should contain 1,000 tables with each table containing 5 integer columns and…

0

Creating Complex Test Databases - Intro

As a very brief intro, I have worked as a tester in SQL Server for the past 10+ years on many different features.  Along the way, we develop and test features and release them to the public only to discover some customers inevitably encounter bugs when they run the features against their databases.  How can this happen when…

4