Excessive memory grants are extremely problematic in SQL Server. These excessive grants do not just happen out of the blue. Memory grants are directly linked to the queries.
The post...
2021-12-31
316 reads
Early on in the history of SQL Server Central, we were offered the chance to work in a booth a TechEd and promote our little site. Brian Knight, Andy...
2021-12-31 (first published: 2021-12-13)
294 reads
I’m thrilled to announce a three-part remote education event in conjunction with the Iowa SQL Server community! The topic is SQL Server IaaS and virtualization performance tuning, and it’s...
2021-12-31 (first published: 2021-12-12)
264 reads
No matter where you are in the world the last couple of years have been, shall we say, difficult. More ... Continue reading
2021-12-30
1 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-30
31 reads
Context I had a request to help with a database from a third-party vendor which uses a lot of FullText-Search (FTS) catalogs. I have to say that I just...
2021-12-29
10 reads
It’s the final week of 2021, a year that was both twice as long and half the length of 2020. If you can, please make sure you are vaccinated...
2021-12-29
10 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-29
8 reads
Queries will fail. That is as inevitable as death and taxes. This article demonstrates how to find some truly horrible queries.
The post Queries that Fail and How to find...
2021-12-29
135 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Working with results and manipulating them is always...
2021-12-29 (first published: 2021-12-20)
348 reads
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
I moved a table from MsSql to Postgresql that had a field defined as...
I tried to find an appropriate forum to post the question. This one seems...
Comments posted to this topic are about the item Resolving Access Denied Errors During...
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers