SvetNas

Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

RE: Rewriting a slow subquery of a view

ben.brugman - Friday, January 20, 2017 2:52 AM
Can you post the table sizes ?
I do not understand the construction around Table_G.
This looks 'nondeterministic' which...

January 20, 2017 at 10:21 am

#1924100
RE: Rewriting a slow subquery of a view

One more thing -
I rewrote the view replacing one of the subqueries (previously for NOT EXISTS) with a left join. This removed the eager spool from the query plan. When...

January 18, 2017 at 3:17 pm

#1923562
RE: Question about CASE WHEN on a column

Luis Cazares - Wednesday, January 18, 2017 11:23 AM
SvetNas - Wednesday, January 18, 2017 11:15 AM

January 18, 2017 at 11:29 am

#1923509
RE: Question about CASE WHEN on a column

Zososql - Wednesday, January 18, 2017 10:50 AM
I am wanting to display a date when a certain condition is met in a column...

January 18, 2017 at 11:15 am

#1923496
RE: Summary table for roll-up

drew.allen (10/4/2016)
SvetNas (10/4/2016)
@drew.allen thanks for the great suggestion! Roll up definitely helps with some levels of aggregation. I don't think it could be used to pre-aggregate data for all...

October 4, 2016 at 7:54 pm

#1904802
RE: Summary table for roll-up

Eric M Russell (10/4/2016)
So, you have this flat denormalized table containing nearly 100 million rows and 100+ columns. The problem is you need to report from it; performing rollups at...

October 4, 2016 at 3:50 pm

#1904791
RE: Summary table for roll-up

@drew.allen thanks for the great suggestion! Roll up definitely helps with some levels of aggregation. I don't think it could be used to pre-aggregate data for all...

October 4, 2016 at 3:39 pm

#1904787
RE: Deploying a copy of existing database with a different name on the same server

Thank you All!

January 10, 2014 at 10:25 am

#1679252

Viewing 8 posts - 1 through 8 (of 8 total)