Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/shivquestpond/public_html/qna/includes/connect.php on line 12

Warning: ini_set(): Cannot change zlib.output_compression - headers already sent in /home/shivquestpond/public_html/qna/datalayer.php on line 12
SQL Server Question and Answer

SQL Server Question and Answer

  • What are data pages and index pages?

    asked on 14th Jul, 2017 by Taj - Category : SQL Server Q & A
    by Rampath Shinde on 16th Jul, 2017
    There are two things data pages and index pages. So we have 8 KB data pages and 8 KB index pages. Page split only occurs for Index pages. For data pages it is but obvious that we need that many data page split. Think if we have 1 clustered index and 10 non clustered index we will have 11 page splits probably. Page split when we mean its only for clustered and non-clustered indexes.Data pages split is just split and not page splits as such.
    1 Answers. Know better answer... Answer Now

We are on Social

Follow us on Twitter

See Hashtag #Questpond on Twitter
to see what others have posted.

Like us on Facebook

See Hashtag #Questpond on Facebook
to see what others have posted.

Follow us on G+

See Hashtag #Questpond on Google Plus
to see what others have posted.

Follow us on Linkedin

See Hashtag #Questpond on Linkedin
to see what others have posted.