Viewing 15 posts - 1 through 15 (of 258 total)
That's an interesting thought.
Thanks Jeff - I'll try out these approaches
May 24, 2022 at 5:25 pm
Great, thanks Grant
I will crack open Extended Events and see what results that brings
October 20, 2021 at 10:07 am
Thanks
Strange, it's not letting me attach the plan - 'Sorry, this file type is not permitted for security reasons.'
Sure I've attached sqlplan files before
This all makes sense
Yes, I suppose the...
July 7, 2021 at 4:48 pm
I'm using SSIS data flow for insertion
From OLE DB to OLE DB
I'm finding that Page compression on a clustered index on the destination table i.e. leave in place, doubles the...
May 18, 2021 at 2:17 pm
Thanks Scott
Cost threshold is 75
There are no non-clustered, just the clustered
May 18, 2021 at 7:34 am
I thought that initially Scott
but, there are 2 seperate tasks both indepdant and both sequential; 1 to populate the table then a second to create the index
It's waiting on the...
May 17, 2021 at 2:54 pm
Thanks
Yes, it's wholesale
Fragmentation post population does not appear to be an issue, so doesn't need rebuilding (99.4%)
If I leave the CIX in place (i.e. don not drop and recreate) and...
May 17, 2021 at 2:39 pm
Yes, same instance
Thanks
May 12, 2021 at 6:43 pm
Thanks
In answer to your question:
1. The source is another table in another database and I am using a dataflow task to move it from one table to another. The source...
May 12, 2021 at 2:57 pm
Great, thanks
I will give that a go
May 10, 2021 at 3:53 pm
Thanks all
So, I've spent a little bit of time on this
I am doing a little bit of manipulation on staging (also comparing to what exists) before moving it live -...
April 19, 2021 at 1:31 pm
Very good set of articles
One question regarding storage and indexes - hopefully it makes sense
Using the sample code.
If I have something like:
select product
, count(*), sum(SalesQuantity)
from...
April 19, 2021 at 1:18 pm
For what it's worth, I'm getting the same issue and have yet to find a resolution
In my opinion, VS is pretty poor when used for SSIS dev. Just too many...
April 10, 2021 at 6:06 pm
Thanks for the response Grant
Think I'll go with the COUNT and COUNT DISTINCT then.
Just wasn't sure whether there's a quicker option (bit like doing a count using sys.table and sys.partition...
July 13, 2020 at 12:20 pm
Thanks Brian and Phil
I'm just going to try a couple of your suggestions and gather some information
March 23, 2020 at 8:15 am
Viewing 15 posts - 1 through 15 (of 258 total)