I've worked on several applications which ride on the external data being received as a flat file every day on an SFTP. The processing time was going beyond...

p.s.  We did do something great on this thread... although it's gotten a bit confrontational, it IS bringing a lot of things to light that people might not have...

I was pointing that out to the OP... Maybe read a little of The Data Warehouse Toolkit to learn how to build star schemas might be in order. I...

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...

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 3 weeks, 6 days 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...