by Eric Isaacs | Jun 6, 2017 | Azure, Blog, Microsoft SQL Server
When scripting out SQL Server objects in earlier versions of SQL Server, you’ve historically had the option to do so with “CREATE”, “DROP and CREATE”, or as “ALTER” scripts. Each option has advantages over the others for…
by Max Petrossian | Apr 11, 2017 | Dynamics 365, Microsoft Dynamics
We’ve probably all dealt with CRM reports in the past. You know, the built-in FetchXML ones? But how many of us have dealt with a SQL report for an online CRM instance? Sometimes the client might ask for a report that is a lot more demanding than what the standard…
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 Eric Isaacs | Feb 20, 2017 | Azure, Microsoft SQL Server
In Transact-SQL (T-SQL) there are two ways to comment SQL code that are similar to comment options in many programming languages. First, there’s the “slash star” (/*) comment block that allows you to comment out multiple rows of SQL. Second,…
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…