how-to-drop-temp-tables-in-sql-server 
SQL Performance
JANUARY 12, 2022
As a reminder, the task involves querying a table called "Auctions."" Use the following code to create the table and populate it with a small set of sample data: DROP TABLE IF EXISTS dbo. Auctions ; CREATE TABLE dbo. . ( Last month , I covered Peter Larsson's puzzle of matching supply with demand.
SQL Performance
SEPTEMBER 2, 2021
SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT().
Expert insights. Personalized for you.
116 
Let's personalize your content