Skip to content

Instantly share code, notes, and snippets.

@VladDBA

VladDBA/gist:176e943b80d763c46c10997dfc70c563

Created February 15, 2024 17:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save VladDBA/176e943b80d763c46c10997dfc70c563 to your computer and use it in GitHub Desktop.
Save VladDBA/176e943b80d763c46c10997dfc70c563 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
USE StackOverflow
GO
ALTER TABLE dbo.Users ADD DisplayNameLength AS LEN(DisplayName);
GO
CREATE INDEX DisplayNameL ON dbo.Users(DisplayNameLength)
WITH(ONLINE=OFF, MAXDOP=0);
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment