Skip to content

Instantly share code, notes, and snippets.

@blacktambourine

blacktambourine/select_filesize.sql

Created November 21, 2017 02:01
Show Gist options
  • Save blacktambourine/9a8cf988f8ae00487b2a98e6c3285fde to your computer and use it in GitHub Desktop.
Save blacktambourine/9a8cf988f8ae00487b2a98e6c3285fde to your computer and use it in GitHub Desktop.
Download ZIP
Get the largest files in your Sitecore database
Raw
select_filesize.sql
SELECT ID, [Name], cast([dbo].[SC_GetSharedFieldValue] (ID, '{6954B7C7-2487-423F-8600-436CB3B6DC0E}') as int) AS FileSize
FROM [dbo].[Items]
ORDER BY FileSize DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment