Prakash K

I am a MS SQL DBA, born and brought up in Mumbai, India. Done my engineering in Electronics And Telecommunications and have been working in this industry as a DBA since 2011

SQLServerCentral Article

Memory Grant Feedback Persistence in SQL Server 2022

By using input from real memory consumption during query execution, Memory Grant input Persistence in SQL Server 2022 is a potent feature that helps optimize query performance. In order to improve the accuracy of memory grant calculations for subsequent executions of the same or comparable queries, SQL Server gathers and stores this information.

5 (3)

You rated this post out of 5. Change rating

2024-06-12

755 reads

SQLServerCentral Article

Deploying Azure SQL Database Using an ARM Template

Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets you use code to automate resource management and provisioning is infrastructure as code (IaC). Azure Resource Manager templates are one IaC solution for Azure (ARM templates).

You rated this post out of 5. Change rating

2024-02-02

1,490 reads

SQLServerCentral Article

Creating a Hyperscale Database in Azure Using the Azure Portal

One of the most effective ways to fully utilize your data is to create an Azure Hyperscale database. The principles of Azure Hyperscale databases have been discussed in this article, including their cost-effectiveness, worldwide accessibility, automatic scaling, and reliable performance.

5 (1)

You rated this post out of 5. Change rating

2023-12-22

1,108 reads

SQLServerCentral Article

Backup and Restore SQL Database to Azure Blob Storage

SQL databases are crucial for businesses, so it's critical to back them up. A dependable and affordable option is offered by Azure Blob Storage. Let's examine the advantages, the steps involved in backing up to and restoring from a device, recommended practices, and more.

5 (3)

You rated this post out of 5. Change rating

2023-09-15

4,780 reads

SQLServerCentral Article

Optimized Plan Forcing with Query Store in SQL Server 2022

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

3,116 reads

SQLServerCentral Article

Exploring Parameter Sensitive Plan Optimization in SQL Server 2022

PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance by accepting varied data sizes based on the runtime parameter value(s) specified by the customer. It deals with the situation in which a single cached plan for a parameterized query isn't the best option for all potential incoming parameter values. Non-uniform data distributions exhibit this phenomenon. When using PSPO, SQL Server keeps several execution plans for a single query, each one customized for a particular parameter value. With the help of this feature, numerous execution plans for a parameterized query are generated, each of which is tailored for a certain range of parameter values.

You rated this post out of 5. Change rating

2023-07-21

2,496 reads

Blogs

Six Months!

By

Oh good gosh. Six months without a single blog post. Most important information: I’m...

Async stats update causing blocking

By

I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up...

Level Up Your SQL Skills: The Best Intermediate to Advanced Courses

By

In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...

Read the latest Blogs

Forums

how to find the cpu memory disk and network of the OS where RDS is residing.

By rajemessage 14195

hi, i have one RDS, but i do not have any other permissions, and...

“user_scans” of table “sys.dm_db_index_usage_stats”

By Meera

I am trying to find answer to the below. What exactly the scan means...

how to assign studentid from one table to other one? please

By Zond Sita

Good Morning,   how to assign query one results to query 2 student id,...

Visit the forum

Question of the Day

A Lack of Memory Grant Feedback Persistence

SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)

See possible answers