The SQL Server 2100 parameter limit is a pain to code around when selecting lots of rows by ID and using batches of parameterized queries doesn't seem to perform very well.
This performance study shows that you should definitely stop using batched parameterized queries for selecting rows by ID. They should be replaced with a temporary table approach for large batches, or constructed SQL strings if temporary tables prove unworkable.Read More
In version 2.8 there's a new equation you can use for calculated metrics called “Period to Date.” You can use this to create metrics with values based on rolling sums of other metrics’ values or thresholds. For example:
would result in a quarter-to-date sum for metric 123's actual value.
When you're adding objects to a dashboard, the first step is to select the organization of the object that you want to add. In version 2.8 We now start with the organization where your dashboard is located, which makes building dashboards much easier.Read More
Are you a recent college grad looking to land that awesome job selling software? Are you an experienced marketing manager looking to make a big career move? Maybe you’re a rock-star developer, looking for the perfect job.Read More