Free SQL tuning tool: How’s My Database?
It’s taken longer than I thought it may and I’ve run into several problems along the way but had a...
2019-02-13
219 reads
Confessions of a Microsoft Addict
Where have I been?
Before you read too far, this is going to be a deeply personal post.Where do I begin? As many of...
2019-02-13
146 reads
Where to watch Ignite
In case you aren’t familiar with #MSIgnite, it’s a huge event where Microsoft debuts all the new shiny software that...
2018-09-24
266 reads
Hello Denver! I’m speaking this weekend
For those of you in the Denver area, SQL Saturday is this weekend! I’m speaking and hope to see you...
2018-09-11
220 reads
Are scalar functions really a bad thing?
I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog...
2018-09-18 (first published: 2018-09-10)
4,012 reads
I’m speaking at SQL Saturday 749 : Baton Rouge
Hello Louisiana! It’s that time of year again. I’ll be speaking on Saturday August 11th in Baton Rouge with many...
2018-07-27
506 reads
SQL Saturday Houston is this weekend
I’m speaking along with many other amazingly talented professionals, including Adam from Guy In A Cube. If you’re in the...
2018-06-19
316 reads
Monday morning comic 2018-05-28
It always seems that when I give a talk on performance there are 100+ people packed in the room but...
2018-05-28
266 reads
You know everything about GROUP BY. Do you?
SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in...
2018-06-01 (first published: 2018-05-25)
5,838 reads
2018-05-21
307 reads
Blogs
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Forums
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers