Explain Concept of SQL Server 8 KB Pages | SQL Server Interview Questions

[@questpondvideos]

20+ SQL Server Interview Questions : kzbin.info/www/bejne/iXbHcnluorh-iZY 20 MSBI Interview Questions : kzbin.info/www/bejne/hKjCpHt7gNOCi6c 10+ Power BI Interview Questions : kzbin.info/www/bejne/eaDdlGyNg6eFqpY SQL Server Joins : kzbin.info/www/bejne/gYXZint7o9mppJo SQL Step by Step - kzbin.info/www/bejne/q3jPl4NvpJyeo7s Software Architecture Interview Questions : kzbin.info/www/bejne/d6W3mJaYgbSkg68 Angular Step by Step Tutorial for Beginners : kzbin.info/www/bejne/Y2q5lIptgqd3qZo 25 Angular Interview Questions : kzbin.info/www/bejne/Y5vIoKx6f6mmia8 35 Important JavaScript Interview Questions : kzbin.info/www/bejne/kJOXlYOfbKh0hLc 30 Important C# Interview Questions : kzbin.info/www/bejne/eHzcn3h4hdacf68 25+ OOPS Interview Questions : kzbin.info/www/bejne/q2qcqHSld893rLM 25 Important ASP.NET Interview Questions : kzbin.info/www/bejne/ponQfpejf7p2Zsk 20 PHP Interview Questions : kzbin.info/www/bejne/Z5PTf4avo7qlopo 5 MSBI Interview Questions : kzbin.info/www/bejne/a3abYmiXjaaqj7M 20 MySQL Interview Questions : kzbin.info/www/bejne/b5nJm3Zjd9WMaJI

[@afzaalawan]

Great explanation - my salute .. thank you Sir (a Pakistani from UK)

[@SudhanshuSingh-ny4dy]

This is really helpful knowing the insights of data pages. But I have a doubt here that since 1033 bytes were left to be filled and the row size is taking 1007+2 i.e. 1009 bytes then why a new page got created for 8th record. Please try to clarify this once you get time. Thanks Sudhanshu

[@todemoura]

I could not understand this at all until you explained it, so thank you so much :)

[@ericx1235]

Fabulous overview of how the pages are stored and how to view them.

[@austincopeland2776]

Couldn't have ask for a better guide.

[@mbigras]

Hi Questpond, thank you for these informative videos, I appreciate the hands on examples and the questions at the end! I think the questions are especially useful to check understanding; however, they are only showed in the video which makes them hard to copy/paste, can you put the questions in the video description? Thank you!

[@ayanvlogs3049]

Well Done Sir.. All my doubts are cleared now on SQL server page topic .....I have liked your video and subscribed your channel.

[@suvarnagaikwad8547]

Questpond .com is very useful Nicely explained concepts

[@RaghuMachineni]

now I have clear structure of pages. thank you very much

[@sumitbhatnagar497]

Thanks for a detailed explanation in simple words. Looking forward to more vids.

[@Njoiraja]

Simplicity is beauty. We would like to see more of SQL server.

[@HarmeetSingh-uz6jo]

This is best way you have explained. Can I have the series link for SQL Server. I am looking for DBA stuffs.

[@PrakashPatil-dw5be]

Good information... Can you please share information about all data page types in detail... Thank you.....

[@abedulhakeemabukhadair4291]

Great explanation or the whole idea thanks. I have only one question regarding Row offset is is calculated as 2*Number of columns ?

[@MrXwings]

Very good and clear explanation of this topic!

[@barath8291]

Really your awesome teaching :). Thanks for this

[@himmatsingh6802]

Excellent Explanation, Appreciate your efforts.

[@joyento]

Well explained, Sir.. looking forward with drill concepts in your upcoming videos.

[@gbengadara2941]

the best video ever.....thank you sir

[@khalidhusain2431]

Very clean explanation. Thank you so much !

[@venkatarajesh2858]

After 7 records, we still have 1033 bytes free in first data page and to accommodate 8th record it needs only 1007 + 2 for row off set total 1009 bytes.Why a new page is created for 8th record.

That was my very same question, but computing is a fallacy so I got over it lol

[@ksathish11]

Wow..very good explanation.. Thank you so much for the great series.

[@jinrajkr4330]

It is very interesting class to watch. Thank you sir.

[@srkidd12]

Actually, there is a 3rd type of sql server file. The ndf file is a secondary database file for isolating data into a separate file and a filegroup.

[@cinithomas6902]

Great explanation.Thank you

[@pritambhattacharjee1199]

WOW....nice demonstration.

[@tushibhaque863]

very well explained... thanks for ur time ..plz make more videos..

[@ritzthoffhen25]

Great description and great work on the video!

[@joanneshapiro8360]

Excellent video - so well explained.

[@devarakondasankararao3802]

Great explanation sir

[@shaikzuhair8537]

Thanks for your short video

[@gauravsrivastava4127]

Very informative.

[@khurramnawaz4434]

Very nice explanation.

[@RC-nn1ld]

Fantastic explanation thank you

[@srenu1214]

Great analysis

[@sairamit1211]

Thank You and Superb explanation.....

[@ericrouach]

great video, thanks a lot!

[@praneethreddyvatti6390]

excellent very clearly explained

[@kaetchen19611]

This video is amazing. Thank you so much.

[@hugokornelis6840]

Thank you, thank you , very interesting!

[@THERESAPARTYINMYHEAD]

This is brilliant, thanks!

[@sanjusanjeet]

I have a simple question. After 7 records, we still have 1033 bytes free in first data page and to accommodate 8th record it needs only 1007 bytes even if we take overheads. Why a new page is created for 8th record. Even i tried it on my local DB and getting same result. Must be my fault. pls clear

[@vigneshwaran911]

Even i had the same doubt..can anyone explain it ?

[@priyankaduggal]

I have the same question. Can somebody please explain?

[@JanardhanReddyTanubuddi]

sanjeet kumar do you have the answer for this question please reply me thank you...

[@dbberater]

Hi Sanjeet. It is because he is using a HEAP (I assume it because I have not seen the full video!). A Heap is a table without any ordering element so data can be stored without "sorting". In a HEAP data get stored by querying the PFS page (Page Free Space) which holds only a percentage value of the filling grade of the page. The percentage is limited to 5 values only: 0: Page is empty 50% 80% 95% 100% I have not seen the video but I would assume that in the demo AFTER entering the 7th record the PFS hit the 95% which means that only 8,060 * 0.95 = 7657 bytes are used. 8,060 - 7,657 - 403 bytes That is - CALCULATED - not enough space for another record. HTH

[@safsafovski7384]

@@dbberater The total size of the page after inserting 7 rows is 7159, which is ~87%. So, indeed there is 1033 bytes left, which is enough for one more row

[@sagarshah275]

Awesome video...thanks a lot.

[@devendra2108]

When we read the data.. Is it read in 8k or 64k?

[@usasenthil]

good one , thanks

[@meetvishal187]

very good info

[@singh.sunder]

Thank you sir. nice video...

[@karthik23839]

great explanation

[@ziaahmedshaikh]

nicely explained!!

[@mdkhan449]

excellent

[@anismzoughi4658]

Thanks a lot☺

[@suvendupatra]

Excellent

[@christianangulo1050]

Thank you, Sir :)

[@YunitaSari-yx8hn]

If a single row contain more than 8KB data, what happen? How SQL split the data to place it in different page?

[@artyomkorbut5623]

thank you

[@crummmycheese]

Amazing video thnx

[@anuragkhare3821]

In TraceOn Command what is 3604..?

[@questpondvideos]

+Anurag Khare Mail us your technical query at [e-mail]

[@anuragkhare3821]

In TraceOn Command what ia 3604..??

[@ibrasami4620]

This trace flag tell sql to print the output locally in SSMS.

[@dbberater]

Really? The answer is shorter than your reference to your email address. TF 3604 routes the output of DBCC commands to the client instead to the error log!

[@Jay-lj2bv]

how pages in dbms different from files in os

[@cnu0870]

Thanks...........

[@shiwanginishishulkar4744]

wow..clear

[@yiyuan6844]

GOOD EXP

[@diwakarverma7153]

aapne system mai kaise kare install sql server

[@MIPunter]

I dont think so noone can explain PAGE in sql better than you

[@sandeshkota3686]

Wondering why TRACEON on number 3604.

[@cietai9843]

The audio is terrible As in unlistenable Did you not test it before recording?

[@ВасилийТолоконников-с7у]

а можно было на русским рассказать? я английский ваше не знаю запиши на русском еще пжпжпжпж