SELECT name, size, used = FILEPROPERTY(name, 'SpaceUsed')...


Please login or register to vote for this query.

(click on this box to dismiss)

DevOps Meta

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT name, size, used = FILEPROPERTY(name, 'SpaceUsed') 
FROM sys.database_files;

/*WITH QuestionsToday AS
SELECT TOP (10) Id, CreationDate
    FROM Posts
    WHERE PostTypeId = 1
    AND DeletionDate IS NULL
    AND CreationDate >= CONVERT(date, getdate())
SELECT * FROM QuestionsToday;;

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results