SQL SERVER – MemoryGrantInfo Property Explanation
I have been writing about the Memory Grant Feedback feature for a while on this blog and I am extremely delighted to see lots of questions and interactions on this topic. Today we will discuss various properties of MemoryGrantInfo in this blog post. If …
Query Performance Diagnostics with sp_PerfSQ
This specialised tool assists with performance analysis and troubleshooting of SQL queries that have active requests (refer sys.dm_exec_requests). The stored procedure collates information from various DMVs in order to provide on-demand deta …
What’s in that database? Getting information about routines
The post What’s in that database? Getting information about routines appeared first on SQLServerCentral.
MemoryGrantInfo – What are Different Status of IsMemoryGrantFeedbackAdjusted? – Interview Question of the Week #253
Question: What are Different Status of IsMemoryGrantFeedbackAdjusted (MemoryGrantInfo Property)?Answer: This question is actually made up by me and was never asked in an interview. The source of the question is all the blog posts that I have been writi …
SQL SERVER – Disable Memory Grant Feedback at Database Level and Query Level
If you are a regular reader of this blog post, you probably know that I have been recently writing a small series on my experience with the Memory Grant Feedback feature of SQL Server 2019. I feel so lucky that in the release of just 3 weeks, I got the …
SQL SERVER – Memory Grant Feedback – No Feedback Disabled
From the last few days, I am sharing my experience with the Memory Grant Feedback feature of SQL Server 2019. I love my job as I get to learn various new technology while working on Comprehensive Database Performance Health Check. Today we will di …
Power BI Filter Pane
The post Power BI Filter Pane appeared first on SQLServerCentral.
SQL SERVER – Memory Grant Feedback – MemoryGrantInfo and IsMemoryGrantFeedbackAdjusted
This is the follow-up blog post of my earlier blog post SQL SERVER – Introduction to Memory Grant Feedback. I just helped the customer gain their lost performance of the SQL Server 2019 while working on Comprehensive Database Performance Hea …
Finding Correlated Rows Using EXISTS or COUNT
The post Finding Correlated Rows Using EXISTS or COUNT appeared first on SQLServerCentral.
SQL Server Doesn’t Encrypt Data By Default.
Create a table and insert a couple of rows: Then back up the database without using compression, and open up the backup file with a hex editor: The same trick works on the data file, too. That’s it. That’s all. That’s the post. Look, …
SQL SERVER – Introduction to Memory Grant Feedback
I just finished helping my second client while working on Comprehensive Database Performance Health Check for SQL Server 2019. The entire experience has been amazing and my client has been extremely happy with how everything ended up. Every single upgr …
Calling all user group leaders! We want to present for you in 2020!
By the end of December, we at SQLskills will have presented remotely (and a few in-person) to more than 100 user groups and PASS virtual chapters around the world in 2019! We’d love to present remotely for your user group in 2020, anywh …
How Does Accelerated Database Recovery Work?
I still remember the time our “Senior Architect” got so frustrated at a long-running transaction filling up the log files that he just deleted the darn things, causing SQL Server to spew memory dumps until we DBAs put the instance out of it …
How to Use CrystalDiskMark 7 to Test Your SQL Server’s Storage
I bet you wanna know whether your storage is hot or not, and there’s no quicker, easier way to get a rough idea of your storage’s capabilities than to fire up CrystalDiskMark. This month, CrystalDiskMark released an all-new version 7, and i …
Moving Encrypted Data to Azure SQL Database
A recent question from a user asked about moving data that is encrypted in a SQL Server database to an Azure SQL Database. In this case, data was encrypted with a symmetric key in a SQL Server database and needs to be moved to Azure SQL Database, where …