Viewing 15 posts - 1 through 15 (of 8,414 total)
Hey Grant,
Thanks for the reply. I'm not upset (was just a bit surprised) and glad you aren't either. No harm done on either side then.
Looking back at the DBA thread,...
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
October 4, 2021 at 2:40 pm
<sigh>
So I post a comment over at DBA Stack Exchange, because I know what I'm posting isn't an answer. I get dinged for it because it almost reads...
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
October 2, 2021 at 2:16 pm
Based on https://docs.microsoft.com/en-us/archive/blogs/craigfr/query-plans-and-read-committed-isolation-level by Craig Freedman of Microsoft.
It would have been nice if you had acknowledged that.
Only committed data is read in the example shown.
There is no guarantee under locking...
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
October 2, 2021 at 1:24 pm
I just came across this article. Nice work, Jeff 🙂
This hadn't occurred to me as a side-effect when I wrote the articles you linked to in the main text.
Cheers!
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
September 20, 2019 at 5:57 pm
As you know, the essential difference with minimal logging is that SQL Server does not log individual rows - it logs at the page and extent level.
For log...
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 23, 2019 at 6:22 pm
Perry,
Thanks for the suggested edit on dba.se but we cannot accept answers in the body of a question.
I'm not sure it makes sense to reopen the old question...
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 14, 2018 at 9:30 am
Contributing a couple of observations:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
August 29, 2017 at 11:06 am
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
August 29, 2017 at 10:10 am
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
August 29, 2017 at 8:38 am
ChrisM@Work (6/30/2015)
Yes! But my explanation is so much better than yours :p
Nothing changes 🙂
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 30, 2015 at 10:19 am
ChrisM@Work (6/30/2015)
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 30, 2015 at 9:50 am
Jeff Moden (6/28/2015)
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 29, 2015 at 1:30 am
The reason I often refer to logical reads of worktables (including spools) being measured in rows rather than pages is an aid to understanding for people who are confused by...
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 28, 2015 at 10:17 pm
Another unfortunate aspect of the XML splitter (aside from barfing on certain characters, and being intellectually offensive ha ha) is that it may perform much, much worse than you would...
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
November 20, 2014 at 7:56 pm
Jeff Moden (10/28/2014)
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
October 28, 2014 at 9:39 pm
Viewing 15 posts - 1 through 15 (of 8,414 total)