Y&L Consulting Inc.
5750 Epsilon San Antonio, Texas 78249
Phone: 210-340-0098
SQL Query and Performance Tuning | IT Consulting Service Provider Company In San Antonio

SQL Query and Performance Tuning

"Y&L analysts were brought in to eliminate data integration failures. An in-depth analysis of system logs was conducted, the server and network infrastructure was reviewed and validated, the integration process and code was reviewed, and data tables were analyzed for improvement. "

"The team incorporated various changes including table indexing and partitioning (which provided the most improvement) and queries were re-written to optimize load performance. Additionally, several automatic and dynamic maintenance plans were implemented."

Tools Used: SQL Server, SQL Server Integration Services, Proprietary front-ends (.Net)