Tag Archives: syndicated

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

Back to Boston for SQL Saturday

Posted on October 1, 2024 by way0utwest

I’m leaving again tomorrow for a trip. This time I head back to Boston for a Redgate DevOps in a Day on Thursday and SQL Saturday Boston 2024 on Saturday. This is a fun event and one I’ve attended the … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Monday Monitor Tip: Compliance Checking for Old Versions

Posted on September 30, 2024 by way0utwest

A customer recently wanted to know if any of their instances were too old and out of support. This was for a compliance purpose, and they had the need to show a report to management of when instances were out … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Comparing an Old Running Total to Window Functions

Posted on September 30, 2024 by way0utwest

Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being introduced. After SQL Server 2012, we had better ways to write … Continue reading →

Posted in Blog | Tagged , , | 2 Comments