Tag Archives: T-SQL

What is Deferred Name Resolution?

Posted on March 3, 2025 by way0utwest

One interesting concept in SQL Server is Deferred Name Resolution. This is something many developers struggle with understanding how this works and where it works. In the Microsoft docs, there is a specific section in the CREATE TRIGGER docs that … Continue reading →

Posted in Blog | Tagged , | Comments Off on What is Deferred Name Resolution?

Declaring a Complex PK in a CREATE TABLE: #SQLNewBlogger

Posted on February 3, 2025 by way0utwest

Recently I was talking with someone who had not named any of the primary keys (PKs) in their database. They used system generated names and when they ran comparisons, they got all sorts of drops and creates they didn’t expect. … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Declaring a Complex PK in a CREATE TABLE: #SQLNewBlogger

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