DATASMITH Blog

0

The Importance of First Column in Nonclustered Index

Does it matter which column is first in an Index? Yes it does, simply because using different columns can result in different execution plans.  Introduction Let’s consider the below select statement – first we will create an index named [IX_OrderDate_ProductKey] on OrderDate and ProductKey and then an index [IX_ProductKey_OrderDate] on ProductKey and OrderDate.

Comparing...

2

How to Create a Measure Group/Table in Power BI

When you have a very large dataset inside Power BI with many tables, it can become hard for a user to find measures or see an overview of all measures at once. Consider the below example, how can a new user know which tables contain measures without opening each one...

0

How to Kill SSAS Cube Stuck in Processing

In this post, I will show you how to kill an SSAS cube which is stuck in processing and cannot be stopped normally. In addition to that, you can also use this method for killing other SSAS related operations. In order to kill a processing cube we need the following...

1

Using Merge & Hashbytes for Slowly Changing Dimensions

In this post, we will have a look at how to perform slowly changing dimensions using MERGE & HASHBYTES. With this method, you can effectively perform INSERT, UPDATE & DELETE operations based on the differences found between two tables, namely, your source & target table. Note: You will be able...

2

A New Way to Deal with “String/Binary Data Truncated”

Anyone who has used SQL Server to insert data into a table has certainly come across the infamous error “String or binary data would be truncated” when data is too large to fit into the target data type. We all know if you are faced with this error, you can...