SQL Server has many undocumented functions and commands. I will write series of posts with functions to have a library online.
OH: A: “What’s the scariest datatype?” B: “What?” A: “a BOOlean” … C: “It’s funny, because it’s TRUE” Lol
The most common and widely used index that we know are nonclustered index. These indexes are created using the famous