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 Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers