Monthly Archives: January 2010

Index to Filegroup mapping

Posted on 28. January 2010 by Bennett

Here is a trivial script to show where a particular index resides. It saves clicking around the SSMS GUI. 1 2 3 4 5 6 7 SELECT i.name, i.type_desc, i. is_primary_key, i.is_unique, s.name AS [Filegroup] FROM sys.indexes i INNER JOIN … Continue reading →

Posted in SQL Server, T-SQL | Comments Off on Index to Filegroup mapping

PowerShell Script to Clean Up Old Files Based on Age

Posted on 20. January 2010 by admin

Here’s an extremely simple PowerShell script to remove old files based on age. You could use it to enforce a policy that keeps 90 days of ETL input files on a server. Files older than that would purged with this … Continue reading →

Posted in Utilities, Windows OS | 3 Comments