Tag Archives: administration

Sparse Columns Can Use More Space: #SQLNewBlogger

Posted on September 10, 2025 by way0utwest

I saw this as a question submitted at SQL Server Central, and wasn’t sure it was correct, but when I checked, I was surprised. If you choose to designate columns as sparse, but you have a lot of data, you … Continue reading →

Posted in Blog | Tagged , | 3 Comments

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