Mensagensdamanha - Tin tức tổng hợp cho mọi người mọi nhà
  • Home
  • Nội Thất
No Result
View All Result
  • Home
  • Nội Thất
No Result
View All Result
Mensagensdamanha - Tin tức tổng hợp cho mọi người mọi nhà
No Result
View All Result

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

admin by admin
June 27, 2020
in Uncategorized
21
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

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

Nguồn: https://mensagensdamanha.com/

Xem thêm bài viết khác: https://mensagensdamanha.com/cong-nghe/

Xem thêm Bài Viết:

  • Mì Tôm TV xem bóng đá miễn phí mượt mà không lo bị giật, lag
  • Kiếm tiền thưởng thả ga, không lo hết vốn cùng Anto247
  • Mua bán nhà mặt phố Bình Tân mới nhất 2022
  • Sinh năm 1998 Mệnh gì? hợp Tuổi nào và Màu gì?
  • Những lưu ý không thể bỏ qua khi sử dụng tủ nấu cơm điện công nghiệp
Previous Post

Cách học Thiết Kế Đồ Họa tốt nhất - Phương pháp tư duy Thiết Kế Đồ họa Cơ Bản đến nâng cao

Next Post

Kiếm Lợi Nhuận 10% Một Tháng Để Tự Do Tài Chính Có Khả Thi Hay Không?

Next Post
Kiếm Lợi Nhuận 10% Một Tháng Để Tự Do Tài Chính Có Khả Thi Hay Không?

Kiếm Lợi Nhuận 10% Một Tháng Để Tự Do Tài Chính Có Khả Thi Hay Không?

Comments 21

  1. DATADECODER says:
    2 years ago

    For Simple Performance Testing. If you want to Create 100K or more tables. Check this video.

    ​https://www.youtube.com/watch?v=amh2IxXUz1c&t=2s

    Note: No Tools or Programming language is required.

    Reply
  2. Soarin Dragon says:
    2 years ago

    A CTE would insert the data much faster than a loop (10x).

    Declare @MaxId int

    Set @MaxId = 300000

    ;WITH cte_Products as (

    SELECT

    1 as ID

    ,'Product – ' + CAST((1) as nvarchar(20)) as Name

    ,'Product – ' + CAST((1) as nvarchar(20)) + ' Description' as Description

    UNION ALL

    SELECT

    cteCust.ID + 1 as ID

    ,'Product – ' + CAST((cteCust.ID + 1) as nvarchar(20)) as Name

    ,'Product – ' + CAST((cteCust.ID + 1) as nvarchar(20)) + ' Description' as Description

    FROM cte_Products cteCust

    WHERE cteCust.ID < @MaxId

    )

    Insert into tblProducts SELECT Name,Description FROM cte_Products OPTION (MAXRECURSION 0)

    Reply
  3. Anusha says:
    2 years ago

    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?

    Reply
  4. t kumar says:
    2 years ago

    You are best person Nice vidéo thanks

    Reply
  5. Ralph Ng says:
    2 years ago

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

    Reply
  6. dennis daniel says:
    2 years ago

    What an explanation? Hats of you sir….

    Reply
  7. Madalin B says:
    2 years ago

    in mysql declare is not recognized, why?

    Reply
  8. Madhavi Bharani says:
    2 years ago

    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

    Reply
  9. DIPALEE G says:
    2 years ago

    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

    Reply
  10. pramod maurya says:
    2 years ago

    Thanks alot

    Reply
  11. Kenneth Hutson says:
    2 years ago

    Unit price should be part of the products table. Total price should be a calculated value in the orders table (quantity*price).

    Reply
  12. Krzysztof S says:
    2 years ago

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

    Reply
  13. Salman Shaikh says:
    2 years ago

    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!

    Reply
  14. Kris Maly says:
    2 years ago

    Revisiting.

    Thanks for educating the community

    Thanks a lot

    Reply
  15. Natural Born Coder says:
    2 years ago

    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.

    Reply
  16. #Stuti# #Tehri# says:
    2 years ago

    great explanation

    Reply
  17. Anurag Vashishtha says:
    2 years ago

    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!

    Reply
  18. ipsita pani says:
    2 years ago

    very nice explanation ,thank u very much.

    Reply
  19. eshwar chowdary Vempati says:
    2 years ago

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

    Reply
  20. kai13man says:
    2 years ago

    Great tutorial…

    Reply
  21. Puurusottam Saha says:
    2 years ago

    wooo woooo……great ..!!

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Xem Thêm

[COMPUTEX 2019] Quick review: Phím cơ xài switch gì mà  lạ thế ???

[COMPUTEX 2019] Quick review: Phím cơ xài switch gì mà lạ thế ???

June 29, 2020
[Đồ chơi] Bàn phím cơ Blue Switch Kailh fullsize LED Rainbow giá rẻ chỉ 600k – Tony Phùng

[Đồ chơi] Bàn phím cơ Blue Switch Kailh fullsize LED Rainbow giá rẻ chỉ 600k – Tony Phùng

June 26, 2020
[Tân Sơn Hội] HƯỚNG DẪN LÀM MỘC | bàn ghế quán cafe bằng gỗ pallet đơn giản

[Tân Sơn Hội] HƯỚNG DẪN LÀM MỘC | bàn ghế quán cafe bằng gỗ pallet đơn giản

June 29, 2020
#dothocung BÀN THỜ TREO TƯỜNG – bàn thờ PHẬT

#dothocung BÀN THỜ TREO TƯỜNG – bàn thờ PHẬT

June 28, 2020
#noithatgiare Bàn thờ ông địa thần tài kích thước siêu to khổng lồ ( hàng hiếm)

#noithatgiare Bàn thờ ông địa thần tài kích thước siêu to khổng lồ ( hàng hiếm)

June 25, 2020
#noithatgiare Bàn thờ thần tài thổ địa mẫu mới nhất 2020

#noithatgiare Bàn thờ thần tài thổ địa mẫu mới nhất 2020

June 29, 2020
  • Chính Sách Bảo Mật
  • Liên Hệ

© 2022 JNews - Premium WordPress news & magazine theme by Jegtheme.

No Result
View All Result
  • Home
  • Nội Thất

© 2022 JNews - Premium WordPress news & magazine theme by Jegtheme.