SORT_IN_TEMPDB = ON; --not working

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources