Continuing the EntryLevel challenge, Aaron Bertrand discusses optimizing the kitchen sink procedure with dynamic SQL and, optionally, OPTION (RECOMPILE).
Category: T-SQL (6)
Aaron Bertrand answers the question "Is a RID Lookup faster than a Key Lookup?" on the SQLPerformance.com blog.
Aaron Bertrand shows that, at least for a large number of...
Aaron Bertrand shares his slides and demos from his two SQL Intersection.
Aaron Bertrand follows up on a recent post about the performance...
Aaron Bertrand explores yet another scenario where a date/time...
Paul Randal (@PaulRandal) continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary table
Paul White shows how an update may fail when a partition has some data on a read-only filegroup, and explains several workarounds.
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.
