SQL Server interview question / training :- What is page split and how is performance impacted?

[@dnfvideo]

Do not miss our Interview Question video series
30 Important C# Interview Questions : ruclips.net/video/BKynEBPqiIM/видео.html
25 Important ASP.NET Interview Questions : ruclips.net/video/pXmMdmJUC0g/видео.html
25 Angular Interview Questions : ruclips.net/video/-jeoyDJDsSM/видео.html
5 MSBI Interview Questions : ruclips.net/video/5E815aXAwYQ/видео.html

[@yogoson8371]

Data type int holds 4 bytes, not 8 bytes.

[@hugokornelis6840]

Good, very good. I shall became good consultant by watching this

[@Shravan_Reddy]

Thank you. how is having a clustered index effecting the performance? If there is no index setup. will the page split effect the performance?

[@MrHajabe]

Its very clear explanation ,well done!

[@RajneeshDabral]

great video. cleared all doubts

[@getreadytotube]

Thanks for explaining this - love the graphics!

[@devarakondasankararao3802]

Nice explanation

[@samjaipal]

Thanks for this video but i a have a question that there is a page split how can we solve this problem to increase the performance

[@sid5201]

de-fragmentation - maintenance plan

[@knyazs]

int takes 4b not 8b

[@surajitkhamrai]

yes you are right

[@satishchandra3076]

Sup exp.