Tag Archives: SQLNewBlogger

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

Rename a Database: #SQLNewBlogger

Posted on November 13, 2024 by way0utwest

I had someone ask me how to rename a SQL Server database recently. They were doing some development work and wanted to rename databases to test an application. I thought I remembered, but in this post, I show I learned … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Counting Groups with Window Functions: #SQLNewBlogger

Posted on October 30, 2024 by way0utwest

I looked at row_number() in a previous post. Now I want to build on that and do some counting of rows with COUNT() and the OVER clause. I’ll show how this differs a bit from a normal aggregate. Another post … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment