T-SQL Programming Aaron Bertrand in T-SQL Programming One use case for NOT using schema prefixes I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server.… 20 April 2023 6 min read
T-SQL Programming Aaron Bertrand in T-SQL Programming GENERATE_SERIES: My new go-to to build sets I have come across a lot of use cases for manufacturing rows on the fly, aside from the common goal of populating a large data... 30 March 2023 12 min read
T-SQL Programming Aaron Bertrand in T-SQL Programming Find 40 Problems in this SQL Server Stored Procedure I’ve been at this for a while now, and have a very particular set of rules and coding conventions that I follow when writing and,... 23 February 2023 21 min read
Blogs Louis Davidson in Blogs Generating Repeatable Sets Of Test Rows In order to test graph structures, I needed a large set of random data. In some ways, this data will resemble the IMDB database I... 30 September 2022 11 min read
Greg Larsen Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen Transact SQL (TSQL) is the languaged used to query and update data stored in a SQL Server. This book, written by Simple Talk author Greg... 20 July 2020 2 min read
Blogs Louis Davidson in Blogs Inline Index Definition There are a lot of features of SQL Server that I (and I know some of you), never really get around to using, usually because... 18 January 2018 3 min read
Phil Factor Reading and Writing Files in SQL Server using T-SQL SQL Server provides several "standard" techniques by which to read and write to files but, just occasionally, they aren't quite up to the task at... 10 April 2007 10 min read
