Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes
Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.
2024-07-22
Query Store
2024-07-17
300 reads
2024-01-29
381 reads
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.
2023-09-04
3,663 reads
2023-04-28
318 reads
2023-02-20
437 reads
2020-12-28
517 reads
2020-11-20
611 reads
2020-02-13
566 reads
Query Store And Cruel Defaults
Erik Darling loves query store, but he really hates the default capture mode.
2019-01-25
2,931 reads
Blogs
A New Word: Fensiveness
By Steve Jones
fensiveness – n. a knee-jerk territorial reaction when a friend displays a casual interest...
Microsoft Purview FAQ
By James Serra
I get many of the same questions about Microsoft Purview, so I wanted to...
Undercover Catalogue 0.4.5 Released – Database Module Bug Fix
Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
Gateway timeout when posting reply but...
I posted a reply to a topic today and, after a minute or so,...
Question of the Day
Disabling Indexes
I want to disable an index so that it doesn't use any resources and isn't maintained. I am planning to drop this, but don't want to do it now. The index is named LoggerNCI and was created on the dbo.Logger table, on the LogID column. What code disables this?
See possible answers