Should Optimistic Be The Default Isolation Level?
Two Words Alright, I’ve lied to you already. There are way more than two words involved, here. I recently had…
2019-05-15
Two Words Alright, I’ve lied to you already. There are way more than two words involved, here. I recently had…
2019-05-15
Last week in our IEPTO2 class I was asked about queries with RECOMPILE and Query Store. Specifically: Do queries that have the OPTION (RECOMIPLE) hint go into Query...
2019-05-14
The first unexpected behavior is one that may already be familiar to many. [Max server memory] is not as often a maximum for SQL Server [total] memory as it...
2019-05-14
This feature works with SQL Server 2019 and onwards. If you are using an earlier version of SQL Server this feature will not work and will give you an...
2019-05-11
How do you know whether a database code change is going to be great, okay or awful? If you want to test a new version of SQL Server how...
The...
2019-05-08
Kitchen Stink A lot has been written about “kitchen sink” queries. A couple of my favorites are by Aaron Bertrand…
2019-05-07
Paul Randal provides a detailed introduction to troubleshooting SQL Server workload performance using wait statistics.
The post Introduction to Wait Statistics appeared first on SQLPerformance.com.
2019-05-07
This weekend I was in Stockholm in Sweden, talking Query Store and plan forcing with Steinar Anderson, when he mentioned the problems he had while forcing plans that had...
The...
2019-05-06
Today I begin a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary job is to help people with my consulting workshop Comprehensive Database...
2019-04-26
A Long Way From Home Most scripts (even ones I’ve worked on!) that look at the plan cache, have had…
2019-04-26
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers