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
Database Performance
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
Yes, pulling just the data you need is really important.
I was asked the other day why a customer was having performance issues on a table. A simple SELECT that ... Continue reading
The post Yes, pulling just the data...
2019-04-24
When READPAST Doesn’t Read Past
Oh, Bother Sometimes, you only wanna work on one thing. Other times, you only wanna work on something if it’s…
2019-04-24
Blogs
Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS
One of the nice things about the Microsoft Connector for Oracle is that it...
ChatGpt Experiments–Getting Documentation
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
A New Word: Jouska
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
Forums
Changing a datasource using T-SQL Script
I've been looking for a way to change multiple data sources for reports to...
Azure SQL Revealed: A Guide to the Cloud for SQL Server
Comments posted to this topic are about the item Azure SQL Revealed: A Guide...
Refresh Limits
Comments posted to this topic are about the item Refresh Limits
Ask SSC