Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 SORT_IN_TEMPDB = ON; --not working

Author  Topic 

Christopher Keveny
Starting Member

1 Post

Posted - 2013-12-11 : 11:55:14
--Here's my query:
USE transactionDB;

GO

CREATE CLUSTERED INDEX CIX_TransactionLog_TransactionTime
ON dbo.TransactionLog
(
TransactionTime DESC
)
WITH(SORT_IN_TEMPDB = ON, FILLFACTOR = 60, PAD_INDEX = ON);

--only when the index is created
--SORT_IN_TEMPDB is set to false for some reason.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2013-12-12 : 14:03:25
It only happens when creating, rebuilding or reorganizing.
When do you expect the index to use tempdb?



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page
   

- Advertisement -