Paul White shows how an update may fail when a partition has some data on a read-only filegroup, and explains several workarounds.
Category: T-SQL
SQL Server 2016 RC0 introduces a new native string splitting function,
STRING_SPLIT.
Aaron Bertrand continues his Back to Basics series, this time discussing SQL Server's synonym and how it can be used.
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.
Aaron Bertrand shares his PowerPoint deck and sample code from his most recent SQL Saturday appearance.
Aaron adds a few tidbits to follow up on his popular post on cursor options.
Aaron Bertrand discusses a couple of potential problems that can occur when you are inconsistent about case sensitivity.
Paul White (@SQL_Kiwi) finishes up his series on the performance of calculating a median with a thorough treatment of eliminating bad elements fro
Paul White takes one more look at medians, this time describing how a locking hint can help improve the performance of a pre-2012 solution.
