﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2008 / SQL Server Newbies  / Nonclustered indexes / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Mon, 17 Jun 2013 22:33:56 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Nonclustered indexes</title><link>http://www.sqlservercentral.com/Forums/Topic870876-1292-1.aspx</link><description>They're stored just like any other value.You can use DBCC PAGE to view data/index pages if you like. It's undocumented, but there are enough articles mentioning it.</description><pubDate>Mon, 22 Feb 2010 23:43:29 GMT</pubDate><dc:creator>GilaMonster</dc:creator></item><item><title>Nonclustered indexes</title><link>http://www.sqlservercentral.com/Forums/Topic870876-1292-1.aspx</link><description>How are null values handled on a column with a nonclustered index?I was asked this question and didn't have an answer. Are the nulls stored in the index itself? Is there a way to view the contents of an index?Thanks!</description><pubDate>Mon, 22 Feb 2010 20:24:44 GMT</pubDate><dc:creator>ABurton</dc:creator></item></channel></rss>