Viewing 15 posts - 1 through 15 (of 1,065 total)
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...
December 23, 2021 at 7:09 pm
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...
December 23, 2021 at 7:01 pm
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...
December 22, 2021 at 7:18 pm
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...
December 22, 2021 at 3:59 am
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...
December 22, 2021 at 3:51 am
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...
December 22, 2021 at 3:45 am
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...
December 21, 2021 at 7:06 pm
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...
December 21, 2021 at 6:46 pm
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...
December 21, 2021 at 6:41 pm
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...
December 21, 2021 at 6:13 pm
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 myTableSELECT...
December 21, 2021 at 5:42 pm
Seems like this user is posting exam questions on the forum.
December 21, 2021 at 5:30 pm
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);goinsert into #myTempvalues ('area_a', 'store1',...
December 21, 2021 at 9:03 am
SELECT DISTINCT [Name] FROM
Should not that be Select distinct @columnsList .... etc....?
I have a feeling you could make use of sp_executeSQL.
December 18, 2021 at 1:42 am
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...
December 18, 2021 at 1:38 am