Bulk editing option in MTM 2013

by Xavier Dilip Kumar 30. September 2014 12:59


1. Open the team project web portal
2. Goto Test tab --> select a test suite --> click on “View List” --> click on “Grid” to view the testcases for bulk edit.




Cleaning up and reduce the size of the TFS database using TFS stored procedures

by Xavier Dilip Kumar 7. September 2014 18:57


  • If your Files table is large:

EXEC prc_DeleteUnusedFiles 1, 0, 100

@partitionId = 1, @chunkSize=100

The nature of prc_deleteunusedfiles is that once it deletes a bunch of files, that causes more files to be able to be deleted due to our delta chains. This procedure is run on a weekly schedule so it will clean up the next set of files the next time the job runs.  This procudure can executed  repeatedly until FWFilesToDelete stops decreasing.This procedure may run for a long time, that’s why it has the third parameter which defines the batch size.

  • If your Content table is large:

EXEC prc_DeleteUnusedContent 1

@partitionId = 1

  • Queries to monitor the DB size

SELECT COUNT(*) FROM tbl_File f WHERE f.PartitionId = 1 AND f.OwnerId = 1 AND f.DeletedOn IS NULL AND f.CreationDate < DATEADD(DAY, -1, GETUTCDATE()) 

AND f.FileId NOT IN (SELECT FileId FROM tbl_Version WHERE PartitionId = 1 AND FileId IS NOT NULL)


SELECT COUNT(*) from tbl_File f WHERE f.DeletedOn IS NOT NULL


About the author

My name is Xavier Dilip Kumar Jayaraj and I am a Software Configuration Management Engineer with a background in application development, Build & packaging using Install Shield.

Profile in LinkedIn


Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs


The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.

Month List