# SQL Server

A Case Study in SQL Performance Troubleshooting

A few months ago, we started to get reports of performance issues from one of our clients. The reports were pretty light on detail, but the gist was that SSAS cube reports built in excel were running slower than usual and sometimes failing to refresh...


SQL Server String Concatenation and Truncation

We use a lot of dynamic SQL in the SQL Server database for our application (it seemed like a good idea at the time), and for some time we’ve noticed some strange issues with strings getting truncated when concatenating large dynamic queries...