Viewing 15 posts - 46 through 60 (of 295 total)
So, when we use linked server (remote query) in the join, is it safe to assume that we won't ever get parallel query plan?
July 17, 2017 at 12:56 pm
That was it. Thank you so much Chris. You are a life savor!!!! Appreciate y'all for help.
July 17, 2017 at 12:51 pm
MAXDOP setting or the Cost Threshold for Parallelism are same. optimize for ad hoc workloads is 1 on server 1 vs 0 on server 2. Would that be it?
July 17, 2017 at 12:42 pm
Good catch. CPU and memory and I/O same. But tempdb config is slightly different. I've tempdb split inot 8 files on server 1 vs 1 file. Would that cause parallel...
July 17, 2017 at 12:07 pm
I ran against SQLSentry and generated the file. It saves as .queryanalysis file. But I couldn't upload them. So, I had to rename them as .sqlplan.
July 17, 2017 at 8:12 am
Thanks. That link gave me 4 hot fix to download. Should I apply all of them or just one of them?
April 17, 2017 at 8:09 am
Here is the actual SQL script. It works in 2005...But just shows NULL on 2014...Please help!!!!
DECLARE @server VARCHAR(500)
DECLARE @DATABASE VARCHAR(150)
DECLARE @TABLE VARCHAR(150)
DECLARE @QUERY VARCHAR(1020)
DECLARE @FILE VARCHAR(250)
DECLARE @PATH VARCHAR(250)
DECLARE...
July 5, 2016 at 6:00 pm
Any help would be much appreciated. It seems like in 2014 its tracking lots of changes than in 2008 R2 even though base table is changed quite a few times.
June 24, 2016 at 8:02 pm
In other words, I'm getting same start_lsn number for so many transactions, which doesn't sound accurate. Is there some settings that I need to look at?
June 21, 2016 at 6:51 pm
Price will never overlap.
April 4, 2016 at 10:10 am
I'm also worried about shrinking 89GB db taking longer to shrink.
December 9, 2015 at 3:14 pm
Writing it as a cross join and I've attached a SQL plan.
There is no keys between these two tables that I could join on. But that is the intent....
October 9, 2015 at 5:41 am
It happens randomly. May be once in 2-3 months. I'm just putting up with it.
May 7, 2015 at 3:19 pm
Viewing 15 posts - 46 through 60 (of 295 total)