ETL #73–NULL or NOT NULL and SQL Interview Questions
Today is the day after Thanksgiving. There are many things to be thankful so I decided to write a short...
2016-11-25
621 reads
Today is the day after Thanksgiving. There are many things to be thankful so I decided to write a short...
2016-11-25
621 reads
We use NON EMPTY key word on the rows axis to remove rows with NULL values. It works only when all...
2016-04-04 (first published: 2016-03-24)
2,434 reads
Dynamically totaling child members
Putting the dynamic totals on top or at the bottom can be a trivial or a big...
2016-03-31
1,196 reads
After I posted this blog MDX Cookbook is a popular book, I received another email from my MDX book publisher.
...
2016-03-24
383 reads
You might have seen error message like this from a SQL job that pulls data from an OLAP cube using...
2016-03-14 (first published: 2016-03-08)
2,228 reads
I cannot believe that I have not posted any blog since May 2015! It’s been a busy few months for...
2016-02-16
1,060 reads
There are many great tips in MDX with SSAS 2012 Cookbook
The book MDX with SSAS 2012 Cookbook has many great...
2015-05-14
1,650 reads
Why a seemingly innocent WHERE clause can cause large amount of data missing
In the previous post, ETL #71–Your data can...
2015-05-12 (first published: 2015-05-03)
6,241 reads
Validations at end of ETL indicate missing data
At the end of each ETL job, I always run some sort of...
2015-04-24
857 reads
The secrete SQLFile.sql
We are all so used to clicking on the New Query icon (or the keyboard shortcut Ctrl+N). We know it...
2015-02-02 (first published: 2015-01-27)
13,427 reads
It’s been forgotten about and neglected for few years but I’ve decided to dust...
I am honored to announce that I have been renewed as a Microsoft MVP...
By Rohit Garg
🔍 Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Navigating Multi Platform Realities in...
I have tried a number of times to export and then import my SSMS...
For the Question of the day, I am going to go deep, but try to be more clear, as I feel like I didn't give enough info last time, leading folks to guess the wrong answer... :) For today's question: You’re troubleshooting a performance issue on a critical stored procedure. You notice that a previously efficient query now performs a full table scan instead of an index seek. Upon investigating, you find that an NVARCHAR parameter is being compared to a VARCHAR column in the WHERE clause. What is the most likely cause of the query plan regression?
See possible answers