
Aaron Bertrand shows that, at least for a large number of...
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.
Kevin Kline shares the slide deck and video from his recent webinar on reducing latency and boosting performance in SQL Server.
Aaron Bertrand shows the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server Query.