Viewing 15 posts - 1 through 15 (of 36 total)
That's something to investigate, but I think the drop and recreating of the indexes is part of the reload. So when an index is built the first time, it creates...
June 20, 2018 at 1:05 pm
That's exactly what I needed! Yes, it's resetting my sampling percent when it auto-updates, so this will hopefully fix it.
June 20, 2018 at 12:05 pm
Yep, bingo, the databases are at different compatibility level. Good call on that Sue, and thanks for the help and verification, Grant. Now to read on about cardinality estimators in...
May 8, 2018 at 1:07 pm
I'm having a moment where I question whether anything I know is true! 🙂 Is my basic understanding of what the context thing does wrong? If I have a query...
May 8, 2018 at 12:01 pm
Ah ok, I see but I'm fully qualifying the DB in the query. Here's the query in question that I used above. Whatever I have selected in the context, it...
May 8, 2018 at 11:37 am
To clarify, I'm running the exact same query, against the exact same database target. It's just the explain plan differs significantly in cost whether or not I have the correct...
May 8, 2018 at 11:29 am
Okay, again, so much clarity in hindsight.
I also see another source of my confusion. Apparently, a stored proc is owned by whoever owns the schema it is in, by...
December 18, 2012 at 9:13 am
Another thing to file in my "bad assumptions" filing cabinet.
Another question, then. When I change the object owner of the proc via sp_changeobjectowner, it changes the schema from dbo...
December 18, 2012 at 8:42 am
Aaaaah, thanks guys. I feel so dumb now. Why are these things always so obvious in hindsight?
The procs were set to EXECUTE AS OWNER, and the database was...
December 18, 2012 at 8:00 am
They're not system processes, though. I see a NTUserName associated with the process and they're executing user stored procs called from a web app.
December 18, 2012 at 7:45 am
Ok, so that mirrors one suggestion the developers have offered here. My concern with that is my company has a policy that we have to be able to assign...
March 6, 2012 at 12:54 pm
That's true. As I understand it, the resource semaphore basically means it's waiting on a chunk of memory to be granted to the task?
The only thing I can think...
April 9, 2011 at 9:08 am
Unfortunately the remote join hint didn't work. Thanks anyway though. 🙂
April 9, 2011 at 9:02 am
Okay, I think it's finally sunk in.
It always takes a snapshot of the db and checkdb actually runs against the snapshot. It will only lock the db if you...
April 8, 2011 at 10:37 pm
Patrick: No differences on the configurations between the two servers.
Gail: Thanks for the clarification. The snap for indexes makes sense, but I definitely see a lock requested and...
April 8, 2011 at 4:22 pm
Viewing 15 posts - 1 through 15 (of 36 total)