Viewing 15 posts - 1,246 through 1,260 (of 49,562 total)
Can you post the execution plan please? Actual plan, not estimated.
June 22, 2017 at 4:48 am
June 22, 2017 at 2:07 am
Can you please find Glenn Berry's wait stats queries, capture the waits at one point, wait a couple hours capture them again, take the difference and post the waits with...
June 22, 2017 at 1:32 am
No.
will it be able to mount databases as long as compatibility modes are intact?
Compatibility level has nothing to do with this. Compatibility level is about...
June 21, 2017 at 1:29 pm
June 21, 2017 at 1:19 pm
June 21, 2017 at 11:03 am
The server-wide waits are uninteresting here, and since they're aggregated from the server start, they're not going to tell you the difference between two statements.
sys.dm_exec_request and the wait_type...
June 21, 2017 at 11:00 am
John Mitchell-245523 - Wednesday, June 21, 2017 8:03 AMWill this one not work just as well?
Yours returns one row per customer...
June 21, 2017 at 8:13 am
What's wrong with group by and having? If you ned to take aggregates per <some column> and filter on those aggregates, group by and having are what you need.
June 21, 2017 at 8:10 am
Did you check for waits, see if the query is waiting for something and if so, what?
June 21, 2017 at 7:49 am
juniorDBA13 - Wednesday, June 21, 2017 5:11 AMWould i be best to just update the local login to another account?
Yes!
The sa...
June 21, 2017 at 5:52 am
I haven't recommended keeping up to the latest version since SQL 2012, 2 year release cycles are tough to keep up with. 18 month is going to be near-impossible.
June 20, 2017 at 2:48 pm
June 20, 2017 at 10:40 am
GA_SQL - Monday, June 19, 2017 8:24 AMAny Troubleshooting/resolution which we can apply to this wait types, please help
Yes, ignore it.
As Jonathan...
June 19, 2017 at 8:37 am
Sorry, that was me mis-reading. I could have sworn that the execution plan you posted was for a delete. Apologies.
Ok, so no blocking. Does the query go suspended...
June 15, 2017 at 4:29 am
Viewing 15 posts - 1,246 through 1,260 (of 49,562 total)