Creating a large table with random data for performance testing Part 61

In this video we will discuss about inserting large amount of random data into sql server tables for performance testing.

In our next video, we will be using these tables, for performance testing of queries that uses subqueries and joins.

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[naturalborncoder]

Great series of videos, this is the first one I've seen anything that I felt needed a comment. At 9:57 you say you should add 1 to produce values between 1 and 5. This is correct but only because the lower limit is 1. If you change the lower limit to 2 and the upper limit to 6 you'll still generate numbers between 1 and 5. The correct thing to do is add lower limit. More formally the subtraction determines the range of the random numbers the addition determines the offset.

[anuragvashishtha]

I have seen the random function being used in some of the legacy code, but have never used it by myself. This video teaches me how and why should i use this function. However, i can sense that in this video, for the first time in this video series, I was a bit lost as to what we are trying to achieve here. I am sure that next video will put all my doubts to rest. Thanks a lot Venkat for making the tough look so easy!

[simon-white]

E.g. for random number between 3 and 5:
Declare @ul int = 5, @ll int = 3;

[krzysztofs]

That's all for today. Thank U Venkat ! You are best teacher I met in my life.
See U tomorrow

[dennisdanield]

What an explanation? Hats of you sir....

[rajupaudel]

great explanation!! Really appreciate it!! Thank you

[krismaly]

Revisiting.

Thanks for educating the community

Thanks a lot

[tkumar]

You are best person Nice vidéo thanks

[ipsitapani]

very nice explanation, thank u very much.

[madhavibharani]

Hi Venkat, Your series is very good. I learn so many new things. Very simple and up to the mark explanations. But for this, I am getting an error while inserting the values in tblProductSales.Error states: The insert statement conflicted with Foreign key Constraint. If you could please tell me what is the cause of this error as I have followed the same code that you have explained in this video. Thanks a lot

[SuperGojeto]

There is slight differences in the counter shown in this video and the counter in your blog. Please correct those if possible.
In the blog, counter is huge (lakh records!) I changed it to those given in the video. Still great video!

[RalphNgOfficial]

hi Venkat, thanks for sharing, should I practice to capitalize SQL reserved word every time when writing my script?

[AnushaCM]

I wanted to understand the difference between SQL and Procedural SQL like PL/SQL or T SQL. I see that you have used coding blocks, declare block etc in this example. In some examples you have also used try/catch block for exception handling. How is it different from Procedural SQL?

[eshwarchow]

I have watched your videos on Indexes. Could you please make some videos on Performance Tuning with Indexed Views.
when we will get more performance with Indexed views?? what is the benefit of WITH (noexpand) at the indexed view declaration??

[DG-wciz]

Use select round(rand()*5, 0) to generate values between 1 and 5. Replace 5 with any number to generate values between 1 and that number

[JFDA]

The initial algorithm for inserting rows into the tblProducts table at 4:33 is missing the @Id. I cannot get it to insert without adding this value so it should look like this

[balamanikanta]

Shall We insert Random Values with Id Based on AutoGenarated GUID/UniqueIdentifier ???

[madalinb]

in mysql declare is not recognized, why?

[nayanamtanuj]

Instead of "1", it should be "Lower Limit" to make the SQL more generic

[yanchuntang]

random number one to five, 1-1.5 1, 1.5 -2.5 2, 2.5-3.5 3, 3.5-4.5 4, 4.5 - 5 5. The probability of 1 and 5 is half of others