Adapted from the post on [How to Find Size of All the Indexes on the Database][1], you can use:

```sql
SELECT OBJECT_SCHEMA_NAME(i.OBJECT_ID) AS SchemaName,
	   OBJECT_NAME(i.OBJECT_ID) AS TableName,
	   i.[name] AS IndexName,
	   i.index_id AS IndexID,
	   8 * SUM(a.used_pages) AS [Indexsize(KB)]
FROM sys.indexes i
JOIN sys.partitions p ON p.OBJECT_ID = i.OBJECT_ID AND p.index_id = i.index_id
JOIN sys.allocation_units a ON a.container_id = p.partition_id
GROUP BY i.OBJECT_ID, i.index_id, i.[name]
ORDER BY OBJECT_NAME(i.OBJECT_ID), i.index_id
```

Which uses the following tables:


* [`sys.indexes`][2]
* [`sys.partitions`][3]
* [`sys.allocation_units`][4]


[1]: https://blog.sqlauthority.com/2016/11/13/find-size-indexes-database-interview-question-week-097/
[2]: https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-indexes-transact-sql
[3]: https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-partitions-transact-sql
[4]: https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-allocation-units-transact-sql


I have an index -- let's call it `IX_MY_INDEX` -- in a SQL Server table (both compatibility modes 80 and 90) that I would like to determine the size of. How do I do this?

**Update:** Allain Lalonde's second solution below only works when the compatibility mode is set to 90; however, the particular database I am working on is in compatibility mode 80. Does anyone have a solution for compatibility mode 80?

How do you determine the size of an index in SQL Server?

## This is now possible with [Static websites on Azure Storage][1]

### Creating a Static Website

1. Navigate to your storage account
2. Select Static Website from the blade and toggle to "enabled"

  [![Add Static Website][2]][2]

3. Once you save, this will create a URL endpoint and also a bucket named `$web` to host your files

   [![Static Endpoint][3]][3]

4. Go to your `$web` storage container and upload any files you want

### Add CDN / Custom Domain

1. Navigate to your CDN Profile and either Create / Edit your Endpoint
2. Select 'Custom Origin' and use the 'Origin Hostname' that was created for your static site

   [![Custom Origin CDN][4]][4]

3. Give Azure up to 30 minutes to propagate all the settings

### Further Reading

* [Tutorial: Host a static website on Blob Storage][5]
* [Tutorial: Use Azure CDN to enable a custom domain with SSL for a static website][6]

  [1]: https://azure.microsoft.com/en-us/blog/static-websites-on-azure-storage-now-generally-available/
  [2]: https://i.stack.imgur.com/qdy7V.png
  [3]: https://i.stack.imgur.com/i1cMA.png
  [4]: https://i.stack.imgur.com/7j6S6.png
  [5]: https://learn.microsoft.com/en-us/azure/storage/blobs/storage-blob-static-website-host
  [6]: https://learn.microsoft.com/en-us/azure/storage/blobs/storage-blob-static-website-custom-domain

I have now successfully setup my static website in a CDN, 
Is there a way to specify that index.html is the default document ?
It is a 1 page site I just would like to browse to the root url without having to type /index.html .. 

Thank you