Monthly Archives: November 2014

Capturing DB Usage stats – sp_spaceused simulation using DMV’s.

SP_SPACEUSED sp_spaceused is one of the system stored procedure used frequently by many dba’s that reveals amount of space used by database/tables. This procedure can be executed either by passing parameters or no parameters. The objective of this stored proc … Continue reading

Posted in SQL | Tagged , , | 2 Comments

Determine size of the file using T-SQL/Powershell/Ole Objects

There are many ways to find the filesize. This post is all about identifing the filesize using T-SQL,Instantiating OLE Objects and PowerShell. The requirement is to retrieve the size of the specified file. The return value is going to a … Continue reading

Posted in PowerShell, SQL, T-SQL | Tagged , , , , , | Leave a comment