Viewing 15 posts - 31 through 45 (of 22,224 total)
DB-300? Is that the code you mean. That's the cert for "Administering Relational Databases on Microsoft Azure."
As for recommendations, I haven't found certifications all that useful in my career. However,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 14, 2026 at 2:20 pm
Thank you, Grant, for sharing what you're working on. My project during my holiday break, isn't as ambitious as yours, but I'm glad I finished it. I started a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 30, 2025 at 4:40 pm
Ha! Yeah, I guess so. Still doing work on it this morning. I'm figuring out if I can get PostGIS installed and then do some additional web pages to show...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 27, 2025 at 4:15 pm
Having just successfully built a functional application using only prompts and agentic AI, dbRosetta if anyone is interested, I have to say, currently, this thing isn't going to replace...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 17, 2025 at 3:00 pm
Q1) You can. I wouldn't because, for most people, this thing is back there running and they never know. It's the hyper-rare workload that will see actual interference from this....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 12, 2025 at 1:57 pm
Yeah, I'd still separate them. Same underlying issues are still there. Different levels and types of IO for each mechanism. Splitting them even lets you pick different levels of IOPs...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2025 at 5:38 pm
Since you are updating manually, I'd break it down a lot more. And, probably run it more often. The key is, how many changes to the data leads to performance...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2025 at 4:51 pm
The bad news, there's no magic formula anyone can provide to give you a perfect answer. You're going to need to experiment with this to figure things out. Sorry.
First things...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2025 at 2:53 pm
Nice to hear it. The hallway track is real. And really helpful.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 24, 2025 at 4:52 pm
It's a big month for me. After 21 years, I'm being made redundant on the 28th when we finally hand over our contract to another company. I started at...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 18, 2025 at 6:09 pm
Just to follow on a little bit.
Columnstore helps with analytical queries. GROUP BY, COUNT, stuff like that which traditional rowstore never handled well. Simply scanning the entire table won't be...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 13, 2025 at 3:25 pm
is this visible?
select @@version
I can't see anything.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 12, 2025 at 2:31 pm
Sorry I haven't been here to respond to you all. I've been traveling quite a bit (typing this in Hong Kong of all places).
What you all say resonates. @EdVassie, yeah,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2025 at 1:19 am
Thanks for the feedback Mandeep. Keep up the good work.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 6, 2025 at 1:37 pm
@grant fritchey
are you feeling bored by any chance 🙂
Nope! Having too much fun.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 6, 2025 at 1:33 pm
Viewing 15 posts - 31 through 45 (of 22,224 total)