Viewing 7 posts - 1 through 8 (of 8 total)
Hi Grant,
We transfered the database to SQL 2014 this weekend, using TRACEON to workaroud the CE.
However, another tiny problem occoured, and we were forced to downgrade the compatibility back...
March 16, 2015 at 6:57 am
Eirikur,
I'll prepare all the information you asked and post here asap.
March 13, 2015 at 1:49 pm
Grant,
I tried the fastest and simplest way to start. I used "DBCC TRACEON (9481);" and ran the query. And ... yes, it performs in only 4 seconds. I tried 4...
March 13, 2015 at 12:57 pm
Eirikur, hi.
The query has 1.823 lines, but the specific part that takes more time to execute is this. Everything before and after this part runs in zero or one second.
;WITH...
March 13, 2015 at 9:01 am
Grant,
I'm sending a small video about my situation here, running the query on SQL 2014, changing the compatibility level and executing the query.
Ignez
March 13, 2015 at 8:28 am
Hi, Grant!
You're right about some aspects.
I really confuse execution plan and maintenance plan. The maintenance plans we apply on these databases updates indexes and statistics. Is there anything else...
March 13, 2015 at 6:11 am
Luis, Hi!
As I mentioned before, I verified the man plan in each scenario. Nothing changes even when I switch the compatibility level.
Erick, Hi!
If the man flush was an issue, I...
March 13, 2015 at 5:16 am
Viewing 7 posts - 1 through 8 (of 8 total)