T-SQL Skills: Loading Millions Of Rows Of Test Data In Seconds

preview_player
Показать описание
Most tools that generate test data do so iteratively. But SQL loves set based operations. With a little T-SQL know how, you can create millions of rows of test data in seconds.

You can even leverage public data sources to create more realistic data that conforms to your applications business rules.

No third party tools, just a handful of queries. I’m keeping it simple.

#sql #csharp #testing #database

Blog:

LinkedIn:

00:00 Introduction
00:13 Why you should generate test data.
01:11 How much data do you need?
01:48 Fake Data
02:48 Sql loves set based operations.
04:05 Fill the table with fake data.
05:38 Realistic test data
06:23 Populating a parent & child tables.
07:39 Leveraging modulus
08:38 Joining with a case statement.
10:45 Let SQL cook.
  1. Jeff Zuerlein
  2. Data
  3. SQL
  4. T-SQL
  5. Testing
Рекомендации по теме
T-SQL Skills: Loading 0:11:19

T-SQL Skills: Loading Millions Of Rows Of Test Data In Seconds

SQL Server 2019 0:00:57

SQL Server 2019 querying 1 trillion rows in 100 seconds

SQL : how 0:01:08

SQL : how do I load 100 million rows in to memory

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Insert One Million 0:12:45

Insert One Million Rows into SQL Server - How to Use SqlBulkCopy

T-SQL: Lock Table 0:04:01

T-SQL: Lock Table On Bulk Insert/Bulk Load

How Smoothly Insert 0:04:06

How Smoothly Insert Millions of Rows in SQL Server?

SQL Query Optimization 0:03:18

SQL Query Optimization - Tips for More Efficient Queries

Connect Your .NET 0:18:16

Connect Your .NET MAUI Application to a Database

How to Update 0:14:58

How to Update Millions of Records in Batch Mode in SQL Server.

5 million + 0:26:03

5 million + random rows in less than 100 seconds using SQL

How to generate 0:15:16

How to generate 1 million random email addresses using SQL

SQL : Best 0:01:24

SQL : Best incremental load method using SSIS with over 20 million records

Vector databases are 0:03:22

Vector databases are so hot right now. WTF are they?

Update a Table 0:07:01

Update a Table with Millions of Rows in SQL (Fast)

New World Record 0:03:55

New World Record Data Loading with SQL Server 2019 in Azure.

Vid 1 - 0:00:52

Vid 1 - Rank() over (Partition by) - SQL Server. #shorts

Performance Tuning In 0:04:40

Performance Tuning In MS SQL Server | Real Time MS SQL DBA Issues Part1

Databases: Average Time 0:02:30

Databases: Average Time to Load 1.2 million records from Oracle INTO SQL SERVER 2008R2

Inserting 10 Million 0:06:45

Inserting 10 Million Records in SQL Server with C# and ADO.NET (Efficient way)

Different Ways to 0:28:51

Different Ways to Load Excel Data into SQL SERVER Table

Day 37 - 0:21:34

Day 37 - SQL - DB, Table Creation and Data Loading

Sql for Beginners 0:00:27

Sql for Beginners - Insert Bulk Records into Teacher Table! Full Course Available #sqltutorial

Migrate Data from 0:26:24

Migrate Data from Oracle to SQL Server Using .net Pipelines - Example

Комментарии
Автор

With privacy being a top concern, this is a great way to not fall in to the trap of using real customer data simply because "it's easy or we've always done it that way before".
Well done Jeff!

mattserdar
Автор

Nice content Jeff! Your explanation helped me to test a bottleneck in a LINQ code I had in the ORM of my application.

thefastjojo
Автор

You’re a legend!! Your content is priceless! Thanks 🤘🏻

dsfgato
Автор

Appreciate you sharing this. Thanks. More of this, please?

everyonesview
Автор

Great video – very useful for testing databases.

As far as I can tell you don’t really utilize to Qty column is you script and the created data just get equally distributed. Do you have a sample of you script where you show the use of Qty?

PerMadsen-tgik