Request Info
Overview DB2 UDB MongoDB MySQL Oracle SQL Server Sybase Teradata


You may face one or more of these time-consuming issues working with MS SQL Server:

  • Unloading and loading large tables
  • Routine utility operations (reorgs)
  • Complex queries
  • Database migration or replication
  • Data discovery: profiling, classification, ERDs
  • Masking sensitive data or generating test data

Specific performance diagnoses and tuning also take time, and may affect other users. Finally, stored SQL procedures may also be programmed inefficiently, require optimization, and then still take too long to run.


Simple, affordable IRI Software addresses these issues. Services are also available for special needs.

Speed Unloads

IRI FACT (Fast Extract) to speed SQL Server unloads. Use SQL syntax in FACT's CLI or GUI to rapidly dump large tables to flat files.

Specify SELECT * from the table so you do not encumber the unload with qualifiers like distinct, order by, and group by. But once that data are in the flat file, use the SortCL program in IRI CoSort to de-dupe, sort, join, group (and report on) the extracts far faster ... in parallel, outside the database.

Speed Loads

IRI CoSort to pre-sort flat files for bulk bcp imports.

Microsoft recommends that almost every SQL Server table should have a clustered index. Create the clustered index first, and pre-sort the input files (on the primary index key) to shorten the create index step. Use the SORTED_DATA option when creating indexes to reflect that CoSort bypassed the slower sort in bcp.

Speed Reorgs and Queries

Offline Reorg wizard in the IRI Workbench to combine and automate the combination of the above fast extraction, sorting, and re-loading operations for classic (offline) SQL Server reorgs, which facilitate the maintenance of your tables in optimal query order.

Optimize Transforms (ETL) and BI Data Preparation

IRI CoSort to relieve the database of processing overhead. Leverage file system I/O, multi-threading, and the proven data transformation power and consolidation of the CoSort SortCL program. Use case:

If you need a faster alternative to SSIS or another ETL tool, see IRI Voracity, a total data managment platform powered by CoSort (or Hadoop), and front-ended in Eclipse for access to (and integration and governance of) multiple data sources.

Migrate and Replicate SQL Server Databases

IRI NextForm 'Database' edition to acquire, re-map, re-format, and build/populate new tables during migrations to and from SQL Server. You can also use IRI NextForm or the SortCL program in IRI CoSort to re-map and convert data in SQL Sever, produce custom reports, copies, and federated views of data.

Classify and Mask Sensitive Data
IRI FieldShield to find, classify, and differentially mask sensitive data in SQL Server, like personally identifiable information (PII) or protected health information (PHI), FieldShield applies masking, encryption, and other de-identifying functions to one or more columns and tables at once. Use FieldShield to comply with privacy laws like HIPAA, PCI DSS, FERPA, and EU DPD.
Generate SQL Server Test Data
IRI RowGen to rapidly populate SQL Server or SSIS ETL operations with safe test data. RowGen uses your data models to automatically generate the test data for an entire database with referential integrity. A subsetting wizard (with masking options) is another included approach.

Request More Information

* indicates a required field.
IRI does NOT share your information.