Viewing 15 posts - 1 through 15 (of 993 total)
It is indeed a brand-new wait type that was added in a recent 2019 CU. I just added it to the waits library - see https://www.sqlskills.com/help/waits/sleep_bpool_steal/ for details....
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 1, 2021 at 10:23 pm
Wow - that's messed up! All of us at SQLskills wish you a speedy recovery!
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
July 7, 2020 at 11:25 pm
Anyone wants any of the non-sterilizable PLA ones, shoot me an email - paul@sqlskills.com. I ship in batches of 10s or 100s.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
April 18, 2020 at 10:27 pm
Hi Kathi, the link at the bottom of your article to Tim's blog post appears to be broken.
https://timradney.com/2020/04/13/3d-printing-for-covid19/?utm_source=ssc&utm_medium=pubemail
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
April 18, 2020 at 10:04 pm
Hey Melissa - I can ship you some PLA ones no problem. Shoot me an email - paul@sqlskills.com. Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
April 18, 2020 at 10:03 pm
We did a bunch of testing back in 1999 when the code was originally written, but I haven't done any large-scale empirical testing since then. Duration is a red herring...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 11, 2018 at 10:00 pm
Thanks for posting all this detail. It certainly looks like for this index, reorganize doesn't give you any gain, but I'm not seeing the proof of your generalization to never...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 11, 2018 at 11:16 am
Of course REORGANIZE itself doesn't cause page splits. The effects of using REORGANIZE...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 10, 2018 at 6:20 pm
And btw, reorganize doesn't cause page splits. Random inserts (or row expansions) cause page splits. Just because reorganize isn't lowering the amount of free space, that doesn't mean it's causing...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 10, 2018 at 5:40 pm
Not taking it as a slam on me at all, nor is my arguing with you here a slam on you - I just don't like the generalization to never...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 10, 2018 at 5:35 pm
Correct. Reorg (and anything else) can't move rows to the right in the index structure (freeing up space), only to the left (taking up space). That's always been the design....
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 10, 2018 at 2:42 pm
Jeff - can you explain this comment you made please: "NEVER USE REORGANIZE!!!! IT DOESN'T WORK THE WAY YOU THINK IT DOES AND IS A LEADING CAUSE OF PAGE SPLITS!!!" Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 10, 2018 at 10:30 am
Hi - unfortunately there's an error in each of your graphical representations of the index structure. For all non-leaf level pages on the left-hand edge of the b-tree, the first...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
May 31, 2018 at 11:44 pm
No problem. Look in your error log to see if there are any message 825s - that proves that it's EMC. See https://www.sqlskills.com/blogs/paul/a-little-known-sign-of-impending-doom-error-825/
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
April 18, 2018 at 1:27 pm
You're getting transient bad page reads from your I/O subsystem - that explains the zero'd page header and the 'weird' behavior you're seeing. Time to get I/O subsystem diagnostics running...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
April 17, 2018 at 4:54 pm
Viewing 15 posts - 1 through 15 (of 993 total)