Viewing 15 posts - 826 through 840 (of 49,552 total)
Please note that the code pattern used here has a severe performance problem.
See https://www.simple-talk.com/content/article.aspx?article=2280 for explanations and options to fix
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
August 28, 2017 at 5:16 am
Please note that the code pattern used here has a severe performance problem.
See https://www.simple-talk.com/content/article.aspx?article=2280 for explanations and options to fix
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
August 28, 2017 at 5:15 am
http://www.sqlservercentral.com/stairway/72399/
http://www.sqlinthewild.co.za/index.php/category/sql-server/indexes/
And that's just the first two that came to mind. Spend some time with your favourite search engine and do some reading.
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
August 28, 2017 at 4:12 am
Without DDL I can't write the query...
Calculate a row_number over the partition and order that you want for the sum. Do that in a CTE. Then join that...
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
August 28, 2017 at 3:01 am
Arsh - Sunday, August 27, 2017 1:36 PMand what are MARS in the connection strings you mentioned above ?
Something that is off...
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
August 27, 2017 at 2:06 pm
Arsh - Sunday, August 27, 2017 12:10 PMdo you think the index fragmentation also is an issue here?
No.
Is the...
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
August 27, 2017 at 2:03 pm
The problem, I suspect, is that log flushes are synchronous. The log has to be written in order, so with 1000 flushes a second, even if you had a 1ms...
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
August 27, 2017 at 9:04 am
Please don't start multiple threads for the same problem
https://www.sqlservercentral.com/Forums/1893974/PLE
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
August 27, 2017 at 9:01 am
Increase PLE: Add memory or reduce need for memory by tuning queries or reducing data. It's not complicated.
PLE is the measure of how long a page will stay in...
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
August 27, 2017 at 8:59 am
Why? If the CTE works, why not use it?
You can do the same thing with a subquery, but it might be harder to read.
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
August 27, 2017 at 6:45 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
August 27, 2017 at 6:40 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
August 26, 2017 at 6:00 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
August 26, 2017 at 5:49 pm
Nothing I said is affected by isolation level.
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
August 25, 2017 at 10:14 am
Every time LineNo resets to 1 (as ordered by recid), you want the chunk number to increase by 1.
Is that a correct summary of the requirement?
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
August 25, 2017 at 7:09 am
Viewing 15 posts - 826 through 840 (of 49,552 total)