Viewing 15 posts - 541 through 555 (of 49,552 total)
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
December 29, 2017 at 9:49 am
Please don't post multiple threads for the same question.
No replies here. Replies to https://www.sqlservercentral.com/Forums/1914800/Need-Help-for-performance
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
December 29, 2017 at 9:38 am
Please don't post multiple threads for the same question.
No replies here. Replies to https://www.sqlservercentral.com/Forums/1914800/Need-Help-for-performance
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
December 29, 2017 at 9:38 am
If that's in a scalar user-defined function, it will be very slow. Nothing you can do about that, functions are very slow. Try converting it to not use a function. 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
December 29, 2017 at 9:30 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
December 28, 2017 at 12:15 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
December 28, 2017 at 11:38 am
There's no reason to have a subquery there.
SELECT [Agent Name] AS AgentName
, [Reason Code] AS ReasonCode
, SUM(Cast(Datepart(Second, [Duration]) AS INT)...
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
December 28, 2017 at 7:33 am
Recompiling it made the problem go away temporarily. It hasn't fixed it. Fixing will require changing the code or using plan guides or query store forced plans (if an upgrade...
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
December 28, 2017 at 7:15 am
Bad parameter sniffing, or some form of unstable plan. Almost always the result of the way stored procedures are written, and fixable by making sure that procedures only have one...
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
December 28, 2017 at 4:18 am
https://www.sqlinthewild.co.za/index.php/2011/08/16/compiles-and-recompiles/
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
December 28, 2017 at 4:14 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
December 28, 2017 at 4:09 am
SQL doesn't use the page file. If it ever gets paged out, something has gone *seriously* wrong (and there will be messages in the error log stating that it's been...
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
December 27, 2017 at 2:55 pm
If you're using Entity Framework, and it's running ad-hoc SQL against the DB, no. Handle the error in your application and present to the user something meaningful.
If you have...
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
December 24, 2017 at 6:56 am
It's not SQL Server. vBulletin uses MySQL. So, given the version, this is MySQL 5.1.54 (still pretty outdated)
This isn't exactly T-SQL afterall - IF(votenum >= 1, votenum, 0)...
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
December 23, 2017 at 4:32 pm
Why is SQL 2016 Enterprise not an option?
SQL 2012 is out of support, so just from that, it's a sub-par choice.
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
December 23, 2017 at 4:09 am
Viewing 15 posts - 541 through 555 (of 49,552 total)