Viewing 15 posts - 1 through 15 (of 22 total)
You mention a few metrics on performance for this method. Do you also have metrics to compare against the merge statement? I'd be interested to see the IO statistics on...
April 15, 2020 at 2:51 pm
You could add a date dimension table to your model. Week count for the year/month/quarter and many others are already in the table, you would have to join to it...
April 1, 2020 at 8:44 pm
Not sure what you mean by "directly", I think that's what I'm asking for.
The sale_result table is only to show you what the sale table would like if the orders...
April 1, 2020 at 7:56 pm
Yes, null ship_date arrives in the sale table before sale_order occurs.
April 1, 2020 at 6:55 pm
You're correct on the denormalization. The goal is to simplify incoming oltp data by giving the ability to update the status of a particular item (backordered, shipped, delivered, event1, event2...
April 1, 2020 at 6:55 pm
Responding to the solution by scdecade, the null values in the sale table must be populated before the sale_order records can be applied.
April 1, 2020 at 6:11 pm
This is for a data warehouse so it would be a batch process. Millions of orders to build it initially and then 100k daily.
April 1, 2020 at 3:41 pm
Thanks for suggestion. I've edited the script and added a result table.
April 1, 2020 at 2:47 pm
Your select statement needs quotes wrapped around the @fltr parameter. Should look like this.
set @qry = 'select * from mydb.dbo.tmptable where color = ''' + @fltr + ''''
When you are...
December 6, 2019 at 8:40 pm
Use the "Include Live Query Statistics" in SSMS. It will show the plan even if the query fails from memory exception.
December 6, 2019 at 8:26 pm
Availability Groups are part of High Availability disaster recovery. Which promises high, not perfect, sql server availability.
December 6, 2019 at 8:12 pm
Yes you will need a license for that. That said, get into a relationship with your licensing rep and get anything they say in writing.
December 6, 2019 at 7:26 pm
Thanks Jeff and John for the help. I ended up rewriting the vw_pos_period_dim as a materialized view. Still not sure why that worked since the view itself performed well, but...
December 6, 2019 at 7:11 pm
The trace flag and the hint that I included do the same thing for the cardinality estimator. I agree the real solution is to adjust the query to fit the...
December 6, 2019 at 2:59 pm
Could you give an example what the...
March 22, 2019 at 6:57 am
Viewing 15 posts - 1 through 15 (of 22 total)