Viewing 15 posts - 1,246 through 1,260 (of 49,552 total)
Can you post the execution plan please? Actual plan, not estimated.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2017 at 4:48 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2017 at 1:29 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2017 at 1:19 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2017 at 8:10 am
Did you check for waits, see if the query is waiting for something and if so, what?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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. Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We stand on the bridge and no one may pass
June 20, 2017 at 2:48 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 15, 2017 at 4:29 am
Viewing 15 posts - 1,246 through 1,260 (of 49,552 total)