I think writing summary queries in T-SQL is the wrong way to go if you're consuming the data in PowerBI. It's fine to create views using T-SQL to populate...

It really depends on whether you understand the consequences of NOLOCK.  It can result in a 'dirty read' if there are uncomitted transactions in the database that affect...

Yes, agree that it would benefit in the read loads. But we should also consider the overhead of CI on write operations. So if the database is read-intensive then...

If you have source control at your shop (like GIT) you may be able to see how other Jobs are scripted and pull out the block of code that defines...

Does an estimated execution plan find any missing indexes?

To speed the query up you could try putting an index on the Customer table with the leading edge on columns...

One example would be when you want to allow select to a 'tableA' from the accountingGroup. Then you realise that there is a member of that group who you would...

I appreciate it is utterly trivial question, and yet... When you have a small amount of columns, there is a simple solution, sort of

INSERT INTO myTable
SELECT...

Seems like this user is posting exam questions on the forum.

This will illustrate what I was trying to point out initially

Try the following sample data and see results

Create table #myTemp(
area varchar(10),
store varchar(10),
totalStoreSales int
);
go

insert into #myTemp
values 
('area_a', 'store1',...

• This reply was modified 5 months ago by  MMartin1.

SELECT DISTINCT [Name] FROM

Should not that be Select distinct @columnsList .... etc....?

I have a feeling you could make use of sp_executeSQL.

If you can post the whole message it would be of help. This could indicate your statistics are outdated. A bad estimation of rows could lead to a scan instead...

You are joining here the forcast on chain and location. Do you need to join on both conditions? In the visualisation tool there may be a setting to treat this...

It fails because the underlying table was created with ANSI_NULLS set to off.

Old post, but I ran into this issue recently.

I get an error when trying to create a 'filtered' non clustered index only. A non filtered variety works just fine. Seems...

This is an excellent diagram. I saved a copy as well.