tag:blogger.com,1999:blog-7468857462999845094.post1845898821787237659..comments2024-03-29T11:33:33.604+05:30Comments on Microsoft SQL Server Knowledge Bank: Index and Disk SpaceMR. JOYDEEP DAS (MVP-SQL Server Year 2012, MVB - D-Zone, MCDBA, MCSE, ADSE, CSI)http://www.blogger.com/profile/15813518881162145877noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7468857462999845094.post-58765055053933695302019-12-11T08:55:24.235+05:302019-12-11T08:55:24.235+05:30New Year images<a href="https://www.newyear2020.co/" rel="nofollow">New Year images</a>imt3jahttps://www.blogger.com/profile/16110347732653474760noreply@blogger.comtag:blogger.com,1999:blog-7468857462999845094.post-78635432129342771622012-07-24T06:46:56.551+05:302012-07-24T06:46:56.551+05:30# When SORT_IN_TEMPDB is set to ON, tempdb must ha...# When SORT_IN_TEMPDB is set to ON, tempdb must have sufficient disk space to hold the largest index (1 million * 200 bytes ~ 200 MB). Fill factor is not considered in the sorting operation. Additional disk space (in the tempdb location) equal to the index create memory Option value = 2 MB. Total size of temporary disk space with SORT_IN_TEMPDB set to ON ~ 202 MB.<br /><br /><br />above is not true. based on microsoft article, about 20% of index size is needed in tempdb if SORT_IN_TEMPDB set to ON.Anonymoushttps://www.blogger.com/profile/15302004668104618716noreply@blogger.com