Dynamically process SSAS Cube from SSIS package
Learn how you can modify an SSIS package to dynamically process SSAS cubes.
2020-01-13
2,534 reads
SQL
How to filter non-existing records in SQL
Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]
2019-11-04
5,383 reads
A User-Defined Function returns more rows
The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]
2019-10-14
3,943 reads
Optimize Your SQL by Reformulating the Spec
As SQL developers, we tend to think of performance tuning in terms of crafting the best table indices, avoiding scalar and table valued functions, and analyzing query plans (among other things). But sometimes going back to the spec and applying some properties of elementary math can be the best way to begin to improve performance of SQL queries which implement mathematical formulas. This article is a case study of how I used this technique to optimize my SQL implementation of the Inverse Simpson Index.
2019-09-12
2,731 reads
Dynamic SQL for beginners in 33 minutes
Learn some of the basics of using Dynamic SQL in a short series of videos.
2019-08-12
7,343 reads
Previous Monday to the Start of the Previous Quarter
Previous Monday to the Start of the Previous Quarter
2019-07-29 (first published: 2019-07-18)
369 reads
SQL and T-SQL for Beginners in 229 minutes
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
2019-07-16
13,056 reads
Blogs
CRM Data Source Connection Error
This article takes us to the edge with a couple of CRM related errors...
SSAS Tabular – Process Add memory consumption
For me it’s a bit surprising how little information can be found regarding the...
Our SQL Server 2019 Administration Inside Out Fun Author Survey
By Will Assaf
SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...
Forums
how to optimise overlap query
-- in following "#t" table one can enter b as 10 and e as...
Parent package calling concurrent Child Packages doesn't fail when child fails
Hi, I have a dynamic child package that gets called concurrently by a parent....
Old Enterprise Licences
It has been a while since I looked at the old licencing and just...
Ask SSC