Viewing 15 posts - 1 through 15 (of 16 total)
August 4, 2017 at 5:06 am
tychopotts - Wednesday, July 5, 2017 10:49 PMComments posted to this topic are about the item SSIS - Execute Package Task
Well...
August 3, 2017 at 1:06 pm
Eirikur Eiriksson (6/9/2015)
FootyRef (6/9/2015)
GilaMonster (6/9/2015)
FootyRef (6/9/2015)
I only want to do the switching of partitions when running the daily ETL processes.
You've talked about having monthly partitions and switching partitions out...
June 9, 2015 at 12:20 pm
GilaMonster (6/9/2015)
FootyRef (6/9/2015)
June 9, 2015 at 6:34 am
GilaMonster (6/9/2015)
FootyRef (6/9/2015)
I only want to do the switching of partitions when running the daily ETL processes.
You've talked about having monthly partitions and switching partitions out of the fact...
June 9, 2015 at 6:19 am
GilaMonster (6/8/2015)
FootyRef (6/8/2015)
GilaMonster (6/8/2015)
FootyRef (6/8/2015)
June 9, 2015 at 5:56 am
GilaMonster (6/8/2015)
FootyRef (6/8/2015)
June 8, 2015 at 10:23 am
GilaMonster (6/8/2015)
Partitioning is not a performance tuning technique.https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
If your query is using the index key (and the index is useful), then only the rows needed will be read anyway.
This...
June 8, 2015 at 9:56 am
So partitioning will not help reporting? I figured that if the query is using the partition key then it would only go to the files that have those values...
June 8, 2015 at 9:27 am
You said that partitioning is not effective but I have heard it is very effective. We have a decent sized data warehouse and I am looking to partition the...
June 8, 2015 at 6:32 am
I guess I am not looking at the performance but looking at the results. Why dowe need to do the join when either query produces the same results?
SELECT .[ID]
...
March 25, 2014 at 2:06 pm
I get the same result doing this simple query:
select *
from #source
except
select *
from #target
Am I missing the purpose of this demonstration?
March 25, 2014 at 12:44 pm
I was not the one who originally asked the question. I just searched and found this answer to a problem I was having here deleting records using a JOIN....
July 9, 2009 at 8:35 am
I was not the one who originally asked the question. I just searched and found this answer to a problem I was having here deleting records using a JOIN....
July 9, 2009 at 8:34 am
I was not the one who originally asked the question. I just searched and found this answer to a problem I was having here deleting records using a JOIN....
July 9, 2009 at 8:33 am
Viewing 15 posts - 1 through 15 (of 16 total)