
Continuing the EntryLevel challenge, Aaron Bertrand discusses optimizing the kitchen sink procedure with dynamic SQL and, optionally, OPTION (RECOMPILE).
STRING_SPLIT
.
Aaron Bertrand describes a few different causes for a symptom you might describe as a "runaway" query in SQL Server.
Aaron Bertrand compares the performance of different UDFs and raw queries used for splitting and reassembling a delimited string.
Aaron Bertrand discusses a few counterpoints to a very thorough and useful post on database naming standards.
Aaron Bertrand revisits whether or not ColumnStore can help pagination workloads.