What is heap table | Full table scan
ฝัง
- เผยแพร่เมื่อ 3 เม.ย. 2021
- Full table scan | Table scan vs index seek | What is heap in sql server | what is heap table in sql | Table scan example | Table scan in sql server
Notes and Slides
www.pragimtech.com/blog/sql-o...
SQL Server Tutorial for beginners
• SQL Server tutorial fo...
SQL Server Interview Questions and Answers
• SQL Server Interview Q...
SQL Server Performance Tuning and Query Optimization
• SQL Server Performance... - วิทยาศาสตร์และเทคโนโลยี
Mr.kudvenkat is excellent, wonderful teacher in the TH-cam community
⭐❤👏🙏
Thank you Asha. Means a lot indeed.
Ur welcome venkat😇
Whenever i get a notification from TH-cam i feel it's from your TH-cam channel😇🤗
This much sufficient information even we will not getting from the paid courses, thanks for the valued information which we need for the real time Project, Normally people having the knowledge on the subject will sell it for cost , but for your genuine teaching god pays you more and more , thanks Venkat , what I'm today that is because of your teaching not my entire education. blessed ❤
One of the BEST video tutorials I've ever seen. Well organized, well spoken, easy to understand with good simple examples. Please keep up the good work so users like me can benefit.
I press the like button even if the video hasnt started yet. Venkat is amazing, blessings and health for you and your family, and everyone out there.
Hello Marco - Thank you so much for your confidence, trust and the wishes. I wish you the same to you and your loved ones. I will do everything in my ability to not let down your confidence and trust.
Tq Marco nagel for such kind words👍
Awesome video Venkat, I am new into DBA and always found your video very detailing and well explanatory. May God bless you. I will like to see a video on performance tuning and HA from you.
Sir! You teach brilliant. I just completed the playlist of c# the way you teach the difficult concept so easily, this would be so appreciable.
Amazing, explained the concept very clearly. Thank you
Hi Venkat, Thank you for creating and sharing such amazing tutorials. I appreciate the effort you put into creating such engaging videos. Looking forward to more from you. If you combine these series of tutorials into one playlist it will be very helpful for us to find out all in one place.
One thing can i say you, you are the best. Please record a lot of SQL server videos. All of your videos amazing
Thank you Isa. Means a lot. Sure, I will cover everything we need to be an effective SQL Server developer.
Always good content with great explanation...
Good detailed explanation and to the point. Thank you
You are very welcome Pringle. Thank you for taking the time to provide feedback.
Great explanation. I always have confusion about how a query works if the table has a non-cluster index and no clustered index. You just cleared that confusion.
Hello Umer - Thank you very much for the feedback. Hope you are finding this SQL performance tuning series useful
Nice we daily type kudvenkat on youtube twice morning and evening and check your channel and awaiting your next videos sir. God blessings and health for you and your family,
I am soo thankful to you sir, that was soo valuable to us.
Simple and superb.
Very clear to the point
Thank you Balakrishna for taking the time to provide feedback. Means a lot indeed.
Such precise teaching.
Best teacher..🙏❤
Good video and good explanation as usual 👏
Thank you Sriharsha for taking the time. It is this feedback that keeps me going 🙂
You're a life saver sir!
Thank you Pubudu for the feedback. Means a lot. Really glad you found the video useful.
@@Csharp-video-tutorialsBlogspot you're the stack overflow of youtube 😋
Thanks. waiting for next bro
You are just amazing.
super and amazing tutorials
Great explanation sir
Great tutorials.
Nice explanation 👌
Venkat sir it’s really good insights and also I liked the way you explains every time, preferring your channel for most of my juniors even on azure also. Could you please restart doing sessions on azure also.! So many of my friends are waiting for your azure videos..!
Thank you very much Sree. Means a lot indeed. Sure, I will resume Azure course as soon as I can. Thank you for sharing our courses with all your juniors. That is indeed a great help.
We are eagerly waiting for your next videos
Sure Mallikarjuna. I will record and upload as quickly as I can. Thank you for taking the time to comment.
perfect !!!! 🙌
Quick question venkat: when db engine uses non-clustered indexes it actually gets a row locator(primary key) using the non-clustered index and then follows a clustered index path using that key right, but in the heap table scenario even if we force it to use non clustered index how does the db engine work with that since there is no clustered index or row locator?
Wow....that's a brilliant question. This is exactly we will discuss in our next video - RID Lookup and Key Lookup. Thank you for your patience.
Why don't you make a playlist for MongoDB too Venkat?
Hello Luigi - Absolutely. These days NOSQL databases are also extensively used. Thank you for the suggestion.
@kudvenkat
Please for ur Blazor Course I' have the same strucutre(blazor server project and api proejct)
every things works fine but I'm confusing in the securtiy Part (i use jwt in api, and in blazor server use scaffold identity like u in ur video)
how can i integrate the securtiy between them
Should i use jwt for both and override authentication state provider or what should I Do
Wait ur response
thanks in advance
What happens if we add non clustered index for every column in the table? Will it performance go down?
Best ever teacher in the world
Thank you very much Kiran. Means a lot. Take care.
Thanks man.
Hi kudvenkat
I am your big fan and fav teacher for me. Thanks for your hardwork and efforts .
I have doubt, any table will store in second storage so, where this heap table will store? Will heap table stores on primary memory/secondary memory (heap means basically I am thinking in primary memory (RAM) ? Is basically heap table used for insertion order storage ? ... Please clarify?
Hello Raja - Thank you very much for the feedback. Heap tables are also stored in the hard disk not in RAM. The major difference between a heap table and non-heap table is, heap tables doesn't have clustered index on them which obviously means the physical order in which the data rows are stored is not guaranteed. Hope this answers your question.
Sir please upload crystal report and report viewer series.. Thanks a lot
Very informative
Thank you Rahul. Hope you are finding this SQL Server Performance Tuning and Query Optimization course useful. The following is the link to the playlist.
th-cam.com/play/PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0.html
Great
neat and clean
Thank you Vijay. Really glad you are finding our videos useful.
Dear vanket plz share the T - Sql series because they way u teach is osam
Please upload the vedioes on T-Sql
Very very thanks in advance
your videos are super sir
make a video on create table without data by using another table metadata.
Sir it's an interview question
Wow...this is a great question Avinash. Sure, I will record and upload as soon as I can. Thank you taking the time to ask.
Select * into NEW TABLE NAME from OLD TABLE NAME
WHERE 1=2
he has already made a video on it as @nileshsoma35 answered u can use that query and provide a condition in where clause which is not true.
Then if do not specify any Cluster index means Heap table then how data is stored in "Data Pages" ? because data pages divide data based on Cluster Index
Awesome Bro
Thank you Naresh. Hope you are finding our courses useful. All the best with everything you are ddoing.
Could you please start a series on MSBI..
Sir, There was a big problem .net EF can't create a table without an Index.
Hi can you please explain about MAXDOP in SQL server. What we can do with this please help it's a commonly asking question in all the interviews
Thank you for asking Suma. Sure, I will record and upload as soon as I can. Great question.
Can you pls make video on angular8 like hostlistener concepts sir
does a table with PRIMARY Key considered as HEAP?
Hi sir can you make video on CSLA framework
Sir can u pls make tutorial on xml data type in ms sql server
What version of MSSQL used in this vid? Thanks
Hello Terence - I am using Microsoft SQL Server 2016.
How to select column data with out comma. For example we had a column called names in that KUD , Venkat. ....etc so how to select all the Names with out a comma.
Thanks,
We can use replace function for columns
Hello Venu - Good question. We can use the LIKE operator along with the wildcard character %. The SQL query is as follows - Select * from TableName where ColumnName not like '%,%'
@@Csharp-video-tutorialsBlogspot sir column name is Name: it has data in this format( (kud, Venkat)(test, name),(test,name2)) same format of data n number of record. I want to select * from table name where column name
To get data with out commas
I am excepting end result like this
1. Kud Venkat
2. Test name
3. Test name2
.
.
How to get this result
Ahhh...Sorry Venu, I misunderstood your question. We can use REPLACE SQL Server function like Kishore said. The following is the query. Hope this helps.
SELECT REPLACE(Name, ',', ' ') as Name from TableName
the ending music, what is its name?
Thanks osam
Plz share link here for SQl job in india & interview point of view vedioes is possible dear
You are very welcome Prasoon. I suggest you follow the below three courses. If you are confident with the concepts discussed in these courses you can clear any SQL interview. You will even be able to work along side experienced SQL developers without any problem.
SQL Server Tutorial for Beginners (All the basic and advanced concepts)
th-cam.com/play/PL08903FB7ACA1C2FB.html
SQL Server Interview Questions and Answers (Very important SQL concepts in this course)
th-cam.com/play/PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR.html
SQL Server Performance Tuning and Query Optimization (Everything you need to improve SQL queries performance)
th-cam.com/play/PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0.html
Thanks dear
Plz share ur mail id i will have some more qureies.
Kudvenkat@gmail.com
Hi Sir, I'm a 31 Y.O. undergraduate and unable to get a job because of my graduation status. I've 2 SQL certifications. One for Oracle Certified Expert, second for Oracle Certified Associate for advance SQL. I'm stuck with 20K salary for the past few years and unable to get SQL job. I've learnt alot from you. Please help me.
Hello Siddhartha - Please send me your CV to kudvenkat@gmail.com and I will forward it to everyone I know. These days education is really not a big blocker to find a good job. I would suggest, build a profile on LinkedIn with all your skills. With many people working remotely and on contract basis, I am sure you will easily find a role that matches your skills. Hope this helps.
🙏🙏🙏🙏🙏