SQL Server 2019 Cumulative Update #17
SQL Server 2019 Cumulative Update #17 is available, with 43 enhancements. The build number is 15.0.4249.2.
Category: SQL Server
Overcoming Challenges with GENERATE_SERIES
I talk about ways to use wrapper functions to work around tedious syntax required by the new function, GENERATE_SERIES.
My 10 Favorite SQLPerformance Posts Over 10 Years
On the 10th anniversary of SQLPerformance.com, I look back on my favorite posts – one from each year.
T-SQL Tuesday #152 : Soapboxing
For this month's T-SQL Tuesday, Deb Melkin asks us get up on our favorite soapbox. I have so many, but this time I picked a new one…
Using a “Goal Posts” Table to Reduce Scan Impact
Logging tables can grow unchecked for years, and date range queries against them get more and more expensive if they don't use the clustered index. Read about one way I've mitigated this problem.
On Cumulative Updates and GDRs
Using a fictitious future timeline, I explain how CUs and GDRs differ and why build number alone might not tell the whole story.
Why shouldn't I create 15,000 partitions in advance?
In this tip, I show some real-life reasons why you may not want to create all the partitions you'll ever need up front.
Bad Habits and Best Practices
An index of over a decade's worth of posts and videos involving bad habits and best practices in SQL Server.
T-SQL Tuesday #151 : Controversial Coding Conventions
I talk about why I prefer CONVERT over CAST to be consistent. Basically, if you sometimes HAVE to use only one, why not just ALWAYS use that one?
SQL Server 2016 Security Update, June 2022
A new build is available for SQL Server 2016 SP2 and SP3. From the CVE: "An authenticated attacker could exploit the vulnerability by executing a specially crafted query using $ partition against a table with a Column Store index."
SQL Server 2014 Security Update, June 2022
A new build is available for SQL Server 2014 SP3. From the CVE: "An authenticated attacker could exploit the vulnerability by executing a specially crafted query using $ partition against a table with a Column Store index."
T-SQL Can Be Expressive Without Sacrificing Performance
There are often multiple ways to express a query and get the same results, often without any change in performance. Learn about one example.
Why is SQL Server's internal database version important?
In this tip, I talk about the compatibility between major versions and SQL Server's internal database version.
Obscure Changes in SQL Server 2022, Part 3 : ShowPlan
I continue looking at some of the changes in SQL Server 2022 that aren't on the marketing slides.
Obscure Changes in SQL Server 2022, Part 2 : Setup
I warn about a cumbersome change to setup, where something is checked by default when it shouldn't be.
New features in T-SQL for SQL Server 2022
The first public preview of SQL Server 2022 is here! Read about my favorite T-SQL enhancements.
Leadership Award from MSSQLTips.com
Today I received a mind-blowing award for my 200th tip at MSSQLTips.com.
Find a string in all views and/or tables in some or all databases
In 2015, I wrote about a stored procedure to find strings within all tables across all user databases. In this follow-up tip, I enhance the procedure to optionally include views and search within specific databases.
SQL Server 2019 Cumulative Update #16
SQL Server 2019 Cumulative Update #16 is available, with 47 enhancements. The build number is 15.0.4223.1.
Building DBML syntax from SQL Server
I show how to piece together portions of SQL Server metadata to generate DBML (which is more useful than it sounds).
Populate dimension tables dynamically – Parts 1 & 2
I wrote two tips around what you can do when a table that stores the same strings over and over again has grown to an unmanageable size: create a dimension table!