This is a simple fake data 🧪 generator script for SQL Server.
While creating this db, my main purpose was to measure performance 🚀 by creating large datasets with non-real datas. For example, I was creating ten million rows of customer tables and trying to create different scenarios to avoid incorrect indexing or expensive execution plans. You can find max value for table rows at the end of the script. All the data is completely imaginary and creates randomly🎡. You should replace them 💭 with your own data because I created the data of content with my native language.
I made the normalisation but also combined other foreign keys to the address table for consistency. You can remove them depend on your cases.:construction:
select top 10 * from [FakeData].[dbo].[Person]
| Id | FirstName | LastName | AddressId | BirthDate | Gender | PhoneNumberId | |
|---|---|---|---|---|---|---|---|
| 1 | Vedat | ISLAKCAN | 8962 | 1984-06-28 00:00:00.000 | 1 | [email protected] | 1687 |
| 2 | Bedirhan | GÜÇER | 1343 | 1962-08-20 00:00:00.000 | 1 | [email protected] | 2781 |
| 3 | Şenay | KİNNA | 1861 | 1964-06-02 00:00:00.000 | 0 | [email protected] | 1720 |
| 4 | İpek | ÖZKARAKULAK | 6748 | 1990-06-04 00:00:00.000 | 0 | [email protected] | 7644 |
| 5 | Evren | YURTKULU | 6893 | 1962-09-15 00:00:00.000 | 1 | [email protected] | 5729 |
| 6 | Bahar | ÇARLIK | 3665 | 1985-07-30 00:00:00.000 | 0 | [email protected] | 1384 |
| 7 | Berivan | ARSLANTUNÇ | 2717 | 1956-11-07 00:00:00.000 | 0 | [email protected] | 5535 |
| 8 | Baran | KEREY | 2778 | 1971-09-04 00:00:00.000 | 1 | [email protected] | 2459 |
| 9 | Alparslan | BALALAN | 9507 | 1964-09-09 00:00:00.000 | 1 | [email protected] | 7529 |
| 10 | Selda | BATTALLAR | 854 | 1998-12-22 00:00:00.000 | 0 | [email protected] | 9036 |
select top 10 * from [FakeData].[dbo].[PersonInfo]/*view*/ order by 1
| CustomerId | Gender | Person | Phone | Address | |
|---|---|---|---|---|---|
| 1 | Bay | Vedat ISLAKCAN | [email protected] | 212-3217885 | Gürler Mah. Cerrah Saliha Sok. Tepebaşı-Taksim/İstanbul |
| 2 | Bay | Bedirhan GÜÇER | [email protected] | 212-4422231 | Zeytinlik Mah. Ezgi Sok. Zeytinlik-Bakırköy/İstanbul |
| 3 | Bayan | Şenay KİNNA | [email protected] | 286-5517987 | Gazi Mustafa Kemal Mah. 18 Mart Sok. Merkez/Çanakkale |
| 4 | Bayan | İpek ÖZKARAKULAK | [email protected] | 216-1341683 | Atatürk Mah. Gaziler Cad. Cumhuriyet-Üsküdar/İstanbul |
| 5 | Bay | Evren YURTKULU | [email protected] | 366-8634023 | İnalı Mah. Emin Ongan Sok. Bingöl-Merkez/Kastamonu |
| 6 | Bayan | Bahar ÇARLIK | [email protected] | 242-7247251 | Yeşilyurt Mah. Saygılı Sok. Yeşilköy-Kemer/Antalya |
| 7 | Bayan | Berivan ARSLANTUNÇ | [email protected] | 282-1333247 | Esenler Mah. Sıran Söğüt Sok. Marmaracık-Ergene/Tekirdağ |
| 8 | Bay | Baran KEREY | [email protected] | 388-1820943 | Bahçelievler Mah. Yunus Emre Cad. Bilecik-Merkez/Niğde |
| 9 | Bay | Alparslan BALALAN | [email protected] | 438-2241223 | Dize Mah. Bulvar Cad. Yüksekova-Yüksekova/Hakkari |
| 10 | Bayan | Selda BATTALLAR | [email protected] | 222-8547251 | Adahisar Mah Yunus Emre Cad. Dinek-Odunpazarı/Eskişehir |
List of most popular given names🔗
Lists of most common surnames🔗
Streets in Turkey🔗
Turkey plate codes🔗
You can create your own large db with Ömer Faruk ÇOLAKOĞLU🔗