by Terrance Zhou | Apr 4, 2017 | Blog, Microsoft SQL Server
Part 1. Know your report’s performance SQL Server Reporting Services (SSRS) is a powerful report building and deployment tool that is frequently used by a large number of institutions. However, a report that needs a lot of time to be rendered is useless as users lose…
by Terrance Zhou | Jan 9, 2017 | Blog
A question that I have been asked several times is how to go about performance tuning with your query. Let’s use a simple scenario here: a colleague comes to you and says, “I’ve written this query and its taking forever! Can you help?” How should you…