Tag Archives: T-SQL

The Lesser Used Functions

Posted on January 10, 2025 by way0utwest

Recently, I reviewed an article that examined the bitwise functions that were added to T-SQL in SQL Server 2022. As I was looking over the article, I started to wonder if anyone was using these in production code. I used … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Lesser Used Functions

Creating a “Real” Copy of a View: #SQLNewBlogger

Posted on December 11, 2024 by way0utwest

I saw a post where a developer was trying to read the Information Schema views to create a copy of a view as a “real” table, a user table. This posts shows an easy way to do this. Another post … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Creating a “Real” Copy of a View: #SQLNewBlogger

FIRST_VALUE vs. Min: #SQLNewBlogger

Posted on December 4, 2024 by way0utwest

I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter asked about the difference between Min() and First_value. This post looks at a few cases. Another post for me that is simple and hopefully serves as … Continue reading →

Posted in Blog | Tagged , , | Comments Off on FIRST_VALUE vs. Min: #SQLNewBlogger

New SQL Server 2022 Functions

Posted on November 22, 2024 by way0utwest

At the recent 2024 PASS Data Community Summit, I saw a lightning talk from Mikey Bronowski on the New T-SQL Functions in SQL Server 2022.  Before the talk, I made a joke with him that none of these were new … Continue reading →

Posted in Editorial | Tagged , | 6 Comments