Viewing 5 posts - 1 through 5 (of 5 total)
Hey thanks for that! I was hoping to optimize the speed and basically understand the "CORRECT" way of doing data processing.
We data process so millions ON THE SAME...
August 30, 2018 at 12:31 pm
Thank you Jeff Moden. I just checked and confirmed that...
August 30, 2018 at 8:50 am
Yeah, it's quite weird. I just hope someone can shed some light on why that would be ?
I want to say I need to rebuild the table but...
August 29, 2018 at 3:23 pm
So my query is :
SELECT OBJECT_NAME(A.[object_id]) as 'TableName', B.[name] as 'IndexName', A.[index_id], A.[page_count], A.[index_type_desc], A.[avg_fragmentation_in_percent],
August 29, 2018 at 12:25 pm
Thanks for that. I will look into star schema. It does look like something that might be better for my type of work. I'm assuming it's because integer id's will...
August 24, 2018 at 4:03 pm