what is sql page split | sql server page split | Sql server performance tuning Part 9
Channel: SS UNITECH
Date: 2019-07-20

SQL SERVER PERFORMANCE TUNING INTERVIEW QUESTIONS AND ANSWERS

Part-6
https://youtu.be/R4wbiGoDjIE

---Script of this video

IF EXISTS (SELECT *FROM SYS.TABLES WHERE NAME ='CRICKETPLAYERS')
BEGIN
DROP TABLE CRICKETPLAYERS
END 

CREATE TABLE CRICKETPLAYERS
(
 NAMES CHAR(500),
 TEAM  CHAR(500)
)
INSERT INTO CRICKETPLAYERS VALUES ('VIRAT KOHLI','INDIA')
SELECT * FROM CRICKETPLAYERS 
DBCC IND('PERFORMANCE_TUNING','CRICKETPLAYERS',-1)
INSERT INTO CRICKETPLAYERS VALUES ('MS DHONI','INDIA')
INSERT INTO CRICKETPLAYERS VALUES ('YUVRAJ SINGH','INDIA')
INSERT INTO CRICKETPLAYERS VALUES ('GLENN MAXWELL','AUSTRALIA')
INSERT INTO CRICKETPLAYERS VALUES ('JAMES MICHAEL ANDERSON','ENGLAND')
INSERT INTO CRICKETPLAYERS VALUES ('ALASTAIR NATHAN COOK','ENGLAND')
INSERT INTO CRICKETPLAYERS VALUES ('ANDRE RUSSELL','WEST INDIES')
INSERT INTO CRICKETPLAYERS VALUES ('CHRIS GAYLE','WEST INDIES')
INSERT INTO CRICKETPLAYERS VALUES ('FAF DU PLESSIS','SOUTH AFRICAN')

DBCC IND('PERFORMANCE_TUNING','CRICKETPLAYERS',-1)
DBCC TRACEON(3604)
DBCC PAGE ('PERFORMANCE_TUNING',1,2489,3)



Find Us On YouTube- "Subscribe Channel to watch Database related videos"          https://www.youtube.com/channel/UCZA_5vGtSpZu86VBDdSnSag

For Quiz-
https://www.youtube.com/watch?v=IaDXFyZSo7Y&list=PLNRxk1s77zfitFbrlRICVDgVodMr25mYl
 
Find Us On FaceBook-
https://www.facebook.com/SS-Unitech-187705388674384/