Editorial

What's Causing the Pushback with DevOps?

  • Editorial

The term DevOps gets horribly abused. Don’t get me started on all the weird additions to it like DevSecOps. No, I just mean the term itself gets beaten up quite a lot. It’s to the point where people are starting to shy away from talking about it. I’ve even changed my approach when discussing DevOps […]

2020-10-24

101 reads

Mentoring

  • Editorial

Over the years when I changed careers and then advanced in IT, many people helped me learn or provided opportunities. Some of these people gave specific in-person help, like my brothers who taught me programming logic and database normalization before I ever thought about working in technology. Others assisted from a distance when I read […]

2020-09-05

83 reads

Controlling Intelligent Query Processing Features

  • Editorial

I always look forward to new T-SQL features and optimizer enhancements with every new version of SQL Server. Starting in 2017, Microsoft came up with a set of features called Intelligent Query Processing (IQP). These features work to improve performance without changing any code. If you’d like to learn more about these features, take a […]

5 (2)

2020-07-11

131 reads

Blogs

Error: 8623 - The query processor ran out of internal resources and could not produce a query plan

By

 Unfortunately a common error in many of our client environments is this: -- Error: 8623, Severity:...

Goal Progress– October 2020

By

This is my report, which continues on from the Aug report. After that report,...

Daily Coping 30 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SQLServer Always-On and Bitlocker

By Lioh

Hi all, we have installed MSSQL 2017 with HA and Always on AGs on...

Any way to use ReportServer in HA AND have two separate SSRS servers?

By C-M-A

This is a little awkward to explain, but we have 2 SQL Server instances...

How to improve the performance of insert?delete?update sql statement

By 892717952

as it was said in the title, which we should pay attention to when...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Best Query

See possible answers