Tag Archives: T-SQL

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

Adding Row Numbers to a Query: #SQLNewBlogger

Posted on October 9, 2024 by way0utwest

I realized that I hadn’t done much blogging on Window functions in T-SQL, and I’ve done a few presentations, so I decided to round out my blog a bit. This post will start with the ROW_NUMBER() function as a gentle … Continue reading →

Posted in Blog | Tagged , , , | 5 Comments

Enabling an Index: #SQLNewBlogger

Posted on October 2, 2024 by way0utwest

I don’t do a lot of work with disabled index, but I learned how to re-enable one today, which was a surprise to me. This short post covers how this works. The Scenario Imagine that you have an index on … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Enabling an Index: #SQLNewBlogger