Microsoft SQL Server

SQLServerCentral Article

Optimized Plan Forcing with Query Store in SQL Server 2022

  • Article

In this Article ,  We will delve into the world of Query Store and explore how to use Optimized Plan Forcing to improve performance in SQL Server 2022. We will discuss what it is, how it works, and how it can impact your system's performance.

5 (1)

You rated this post out of 5. Change rating

2023-09-04

4,381 reads

SQLServerCentral Article

SQL Server Resumable Index Operations

  • Article

The ability to pause and then resume index rebuilds has been added to SQL Server. This is a fantastic feature, and with the release of SQL Server 2019, we can now replicate it on the actual create index process. Learn how to use this feature in this short article.

5 (3)

You rated this post out of 5. Change rating

2023-06-26

9,737 reads

SQLServerCentral Article

Running SQL Server on Oracle and Google Cloud

  • Article

In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.

4.2 (5)

You rated this post out of 5. Change rating

2022-02-18

6,963 reads

Blogs

Monday Monitor Tips: VLF Alerts

By

A recent change made to Redgate Monitor to add a new alert for VLF...

Using T-SQL Snapshot Backup - Seeding Availability Groups

By

In this post, the fifth in our series, I want to illustrate an example...

A New Word: Tangency

By

tangency– n.  a fleeting glimpse of what might have been. I tend to live...

Read the latest Blogs

Forums

Keeping QUERIES for Using Again and Adding DB to Git/Github and VS Code

By Ahr Aitch

While I know that it will speed my learning to type queries as I...

Found a Tool Very Helpful for Beginner

By Ahr Aitch

I struggled with remembering the conventions I'd chosen when creating column names and data...

Is anybody using Windows 2022 clustered SQL Failover cluster ( 2019 CU30 )

By Johan Bijnens

How do you configure the cluster resources to be able to use Distributed Transactions...

Visit the forum

Question of the Day

Partial Backups I

What is a partial backup for a read-only database?

See possible answers