- 8
- 125 369
JiFacts
Romania
Приєднався 3 вер 2016
This channel is all about coding ...(SQL, Android, Swift, Kotlin, PHP, JAVA, C#, etc....) you got the point :)
How sql indexes work- Nonclustered and Clustered
Welcome to your comprehensive guide on SQL indexes! In this informative video, we delve into the intricacies of clustered and non-clustered indexes in SQL Server, unraveling their significance and helping you optimize your database performance.
🔍 Master the fundamentals: We start by demystifying the concept of indexes and their critical role in enhancing query performance. Whether you're a beginner or an experienced developer, this video offers valuable insights to deepen your understanding.
🎯 Clustered Indexes Unveiled: Learn how clustered indexes physically sort and store your data, providing efficient access to information. We walk you through their structure, the importance of choosing the right column as the clustered key, and their impact on data insertion and retrieval.
🔧 Non-Clustered Indexes Simplified: Uncover the power of non-clustered indexes in improving query speed by creating separate data structures. We explain the key differences between clustered and non-clustered indexes, guiding you in their implementation for optimal performance gains.
⚡ Boosting Query Performance: Discover the art of selecting the ideal index strategy based on your specific workload. Our expert tips and best practices empower you to identify scenarios where clustered or non-clustered indexes shine, ensuring your SQL Server environment runs at peak efficiency.
📈 Elevate Your Database Performance: By the end of this video, you'll possess a solid understanding of clustered and non-clustered indexes, equipping you with the knowledge to make informed decisions when it comes to optimizing your SQL Server databases.
🔔 Don't miss out on our exclusive SQL tutorials! Subscribe now and stay up-to-date with our latest videos, empowering you to harness the true potential of SQL indexes and take your database skills to the next level.
👍 Like, comment, and share this video with fellow SQL enthusiasts and professionals seeking to enhance their understanding of clustered and non-clustered indexes. Let's unlock the true power of SQL together!
#SQL #SQLServer #IndexesExplained #ClusteredIndexes #NonClusteredIndexes #DatabasePerformance #QueryOptimization
Remember, understanding SQL indexes is the key to unlocking blazing-fast query performance. Watch now and take control of your database efficiency!
🔍 Master the fundamentals: We start by demystifying the concept of indexes and their critical role in enhancing query performance. Whether you're a beginner or an experienced developer, this video offers valuable insights to deepen your understanding.
🎯 Clustered Indexes Unveiled: Learn how clustered indexes physically sort and store your data, providing efficient access to information. We walk you through their structure, the importance of choosing the right column as the clustered key, and their impact on data insertion and retrieval.
🔧 Non-Clustered Indexes Simplified: Uncover the power of non-clustered indexes in improving query speed by creating separate data structures. We explain the key differences between clustered and non-clustered indexes, guiding you in their implementation for optimal performance gains.
⚡ Boosting Query Performance: Discover the art of selecting the ideal index strategy based on your specific workload. Our expert tips and best practices empower you to identify scenarios where clustered or non-clustered indexes shine, ensuring your SQL Server environment runs at peak efficiency.
📈 Elevate Your Database Performance: By the end of this video, you'll possess a solid understanding of clustered and non-clustered indexes, equipping you with the knowledge to make informed decisions when it comes to optimizing your SQL Server databases.
🔔 Don't miss out on our exclusive SQL tutorials! Subscribe now and stay up-to-date with our latest videos, empowering you to harness the true potential of SQL indexes and take your database skills to the next level.
👍 Like, comment, and share this video with fellow SQL enthusiasts and professionals seeking to enhance their understanding of clustered and non-clustered indexes. Let's unlock the true power of SQL together!
#SQL #SQLServer #IndexesExplained #ClusteredIndexes #NonClusteredIndexes #DatabasePerformance #QueryOptimization
Remember, understanding SQL indexes is the key to unlocking blazing-fast query performance. Watch now and take control of your database efficiency!
Переглядів: 3 939
Відео
Python Scraper - Google Play and App Store Reviews
Переглядів 15 тис.2 роки тому
This a a web scraper written in Python to get all the reviews for an app from Google Play and App Store. The apps that are used in the video: Google Play: play.google.com/store/apps/details?id=com.apphup.passwordmanager&hl=en&gl=US App Store: apps.apple.com/ro/app/password-manager-myvault/id1138075747 The code: from google_play_scraper import app, Sort, reviews_all from app_store_scraper import...
Power BI - How to get latest info from a dataset for a column
Переглядів 1762 роки тому
We have a set of CSV files stored in a specific folder. Each CSV contains sales data. We extract the latest transactions from each file and we calculate the total sales amount for those records.
PowerBI - How to count duplicate values
Переглядів 36 тис.2 роки тому
How to count all duplicate values from a table, using DAX. Also how to count all values with an exact number of occurrences.
cross apply - cool trick in sql server
Переглядів 13 тис.5 років тому
In this tutorial I will show you a cool trick of how to write less code using CROSS APPLY in SQL Server.
SQL Performance - Functions in SQL Server
Переглядів 2995 років тому
In this video I will show you the advantages and the disadvantages of using user defied functions in SQL Server. Check out other cool tutorials: How to parse a JSON in SQL Server: ua-cam.com/video/0Zm41iZzbnI/v-deo.html How to concatenate multiple rows in one string: ua-cam.com/video/l0xwh6UGBbo/v-deo.html
How to read JSON in SQL Server
Переглядів 37 тис.5 років тому
In this tutorial I will show you how to parse a JSON object in any SQL Server version that supports native JSON parsing. Below is an example with all the things that you need to know: JSON Object DECLARE @JSON_DATA NVARCHAR (MAX); SET @JSON_DATA = '{ "squadName": "Super hero squad", "homeTown": "Metro City", "formed": 2016, "secretBase": "Super tower", "active": true, "members": [ { "name": "Mo...
SQL Server - Concatenate rows into a string
Переглядів 21 тис.6 років тому
This video will show you how to concatenate multiple rows into a single string in SQL SERVER. Of course there are multiple solutions for this situation, but this is the way I prefer doing it. :)
Well explained
Excellent Explanation, great
Simple and very useful. Thank you.
Thanks very much easy to understand
It was very helpful , thanks <3 keep up the good work
excelent explanation, thank you
you can use "countrows" instead of "countAX" to make your code simpler but thank you that exactly what I need.
Thats the explanation i was looking for.Thanks!!
me too 😉😉😉
Nice explanation. Thanks for sharing knowledge
This is exactly what i needed! Worked so well! Great explanation!
Very good explanation.
Thanks so much for this!
AMAZING!!! This is exactly what i was looking for to solve a request at work. Thank you for the clear explanation and break down as to how/what was happening as you compiled the whole expression.
Bug free code that helped me with a capstone, thanks for the huge assist.
Currently trying to find a workaround for the google_play_scraper. When reviews_all is run on some applications, there is not a 'userImage', or 'reviewCreatedVersion'. This results in a KeyError: .... not found in axis.
Clear explanation. Keep it up😍
You are a machine my friend!
what am i doing wrong its not working with me for google play
you are awesome. exactly what I was looking for, with detailed explanation of the thought process. Thank you for taking the time to explain it
You're the real G ❣️ Thank you so much 👍
Any idea how to scrape all countries most efficiently? maybe without using a loop to iterate through the entire countries list?
Helpful!
Anyone knows how to scrape the only 1000 latests reviews of an app in play store? thanks!
What if i have to fetch names of application like i dont want to add name it can fecth available names and show rhe results
why doesn't it work on Netflix?
Very useful! Thank you!👍
helps a lot thank you
This was so amazing! Thank you so much for this tutorial, it's really easy to understand!!!
I want to show the name, how do i do that?
Worked perfectly. Thank you!
doesnt work
Zoom please
Very much educational...thanks.
got currupted through is
Thank you ! Super video !!!
How can i show the duplicate count for every name? In your case i want to show i a table and maybe a graph that john is repeated 3 times and Olivia is repeated 2 times. I have different customers names and when they got a discount, i want to show that John is repeated 5, times for example, and 3 times he got a discount, Marrry is repeated 3 times and she got a discount only 1 times. At the end i want to show only the once that ot a discount more than 2 times.
same ques
This was absolutely amazing. Lifesaver.
You are god
Awesome Thank you for this tutorial.
thankyou soo much sir😀
Thank You for your tutorial, it did help me lot. Recently I tried to scrap from popular app and it had above 1 million reviews, would it be possible to request only 50K data or review of 1 year only. Would be much more thankful for your help
Hi, have you found a Solution for this?
Hi, you can read the documentation for the scraper libraries he used to know if such options are available. Alternatively, you can work around it, given that you have the review_date column. You can fetch the data first and use pandas to filter for the date range of interest.
i like 7:52
Could you please mak a video for claculate duplicale more the 2 times thae last 3 or 4 4 weeks
Creative idea, looking forward to more tutorials.
Please use ZOOM because it's impossible to read, thnks
Thank you! Beautiful video. It has helped me immensely with a major project. You shared EVERYTHING that I needed to know. I especially appreciate you including the "powers" array, because accessing those elements has been left out on every other tutorial I found before this.
really informative
Thanks, this solved my problem.
🌺 Ｐｒⓞм𝕠𝕤𝐌
Thanks for the informative video; we can use this information immediately!
Very useful and good explanations.