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...

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...

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...

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...

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...

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...

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...