Tag Archives: administration

Guidelines and Requirements

Posted on September 5, 2025 by way0utwest

I saw a post from Brent that Microsoft had changed the default memory guidance. At first glance I read this as they’d changed the default values, which would be interesting. However, this is a guideline, set to 75%. I also … Continue reading →

Posted in Editorial | Tagged | Comments Off on Guidelines and Requirements

T-SQL Tuesday #186–Agent Jobs

Posted on May 13, 2025 by way0utwest

It’s that time of the month again, when the T-SQL Tuesday blog party takes place. I manage this site, and am looking for hosts all the time. This month I managed to convince Andy Levy to host, and I’m grateful … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Create a Linked Server: #SQLNewBlogger

Posted on May 5, 2025 by way0utwest

I had a customer recently that was asking about Linked Servers and some development advice. I was going to show them a few things and realized I hadn’t created a linked server in my demo environment, so I did it … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Create a Linked Server: #SQLNewBlogger

Index Maintenance Can Change NORECOMPUTE Settings

Posted on April 30, 2025 by way0utwest

I had a customer recently ask about a change in one of their constraints on production, where a new option appeared when they went to deploy some changes from QA. They asked how this could happen, and I’ll show how … Continue reading →

Posted in Blog | Tagged , | Comments Off on Index Maintenance Can Change NORECOMPUTE Settings