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
Database Performance
Queries with RECOMPILE and Query Store
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
SQL Server 2017: here a NUMA, there a NUMA...
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
SQL SERVER – Get Last Known Actual Execution Plan for a Previously Cached Query Plan
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 to load test a SQL database
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
The Only Thing Worse Than Optional Parameters…
Kitchen Stink A lot has been written about “kitchen sink” queries. A couple of my favorites are by Aaron Bertrand…
2019-05-07
Introduction to Wait Statistics
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
Query Store, Plan Forcing and Table Variables
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
SQL Server Monitoring Week – SQL Plan Warnings
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
Why Plan Cache Scripts Can Be Misleading
A Long Way From Home Most scripts (even ones I’ve worked on!) that look at the plan cache, have had…
2019-04-26
Blogs
Secure Azure SQL Server Backups Using Managed Identities
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell
As AI continues to evolve, many of us are looking for ways to leverage...
Monday Monitor Tips: Finding the Hostname for Queries
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Forums
Internationalisation
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Size of DB on physical disk doesn't match Disk Usage by Table report
Hi everyone I am looking at the size of my db on disk (ie...
Getting the TEXTSIZE
Comments posted to this topic are about the item Getting the TEXTSIZE
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers