Improving Your Insight SharePoint and Teamcenter SQL Server Performance By 460% with Index Defragmentation

Courtesy of the SQL Fool an awesome script to defragment the SQL Server indexes.   This is a maintenance script and can be useful for improving your overall SQL Server performance issues.

SQL utility and maintenance scripts can be applicable for both Insight and TCX installations running SQL Server.

So does index defragmentation matter?  From Microsoft SQL Server 2000 Index Defragmentation Best Practices: 

"The workload performance increase realized in the small-scale environment ranged from 60 percent at the low level of fragmentation to more than 460 percent at the highest level of fragmentation. The workload performance increased realized for the large-scale environment ranged from 13 percent at the low fragmentation level to 40 percent at the medium fragmentation level."

So how to use this defragmentation script?

Purging Solid Edge Embedded Client Unreferenced JT Override Datasets from Teamcenter

In Solid Edge Embedded Client (SEEC) when creating assembly features a JT dataset is created and uploaded into Teamcenter.  This assembly feature JT dataset is commonly referred to as a "JT override".  SEEC JT override dataset names take the form of "Ovr_<id #>" where <id #> is some system generated id number.