Viewing 15 posts - 826 through 840 (of 22,224 total)
Thanks for all the feedback everyone. Appreciated.
Me, I love tuning queries.
Yes Jeff, working on the new book. Chapter 20 right now, Graph data.
@Grant ,
Awesome... I don't know how...
"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
July 26, 2022 at 11:27 am
Thanks for all the feedback everyone. Appreciated.
Me, I love tuning queries.
Yes Jeff, working on the new book. Chapter 20 right now, Graph data.
"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
July 25, 2022 at 1:18 pm
Have fun with the baseball. Most fun I've had is going to the games with Allen White. I like watching him watch the game. Far more fun than the game...
"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
July 19, 2022 at 7:56 pm
Thanks Rick, but I'm not actually going to Gettysburg this trip. Sorry for the confusion. This time it's Pea Ridge and Vicksburg.
"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
July 19, 2022 at 7:55 pm
Uh oh. All the shame.
Thanks Steve.
Appreciate it Luther. I plan to hit the Virginia battlefields someday.
Tom, not sure, but I had a blast tromping around the Gettysburg battlefield with the...
"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
July 19, 2022 at 1:14 pm
Yep. Pretty much.
Ha!
"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
July 16, 2022 at 1:01 pm
The optimizer will absolutely rearrange your WHERE clause. It's part of how it works. It'll also rearrange and reorder your JOINs. So, from the most simplistic approach, WHERE & JOIN...
"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
July 14, 2022 at 1:59 pm
Just piling on with @ratbak
Every object in your queries should be qualified with the schema owner. If for no other reason, it reduces, in ever so tiny an amount, the...
"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
July 14, 2022 at 1:50 pm
Thanks everyone for the feedback so far. All jives with my understanding. I've just never heard the phrase "healthy deadlocks" before, so I was curious what others thought.
"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
July 13, 2022 at 8:09 pm
Question for the smart people, and the rest of you.
Would you endorse or get behind the statement:
Some deadlocks are healthy.
or
Some level of deadlocks is healthy.
Or is more something like:
Some level...
"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
July 13, 2022 at 6:43 pm
Backups should be run serially. I tried running them in parallel. It's a great way to bring down a server. So yes, most tools, software and suggested solutions, show backing...
"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
July 12, 2022 at 1:18 pm
If you're just looking at hosting a container, all the cloud vendors do it. Amazon ECS is one option. Azure Container Hosting is another. Pricing-wise, they're pretty similar. Better to...
"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
July 12, 2022 at 1:16 pm
If you're looking for truly legit certification courses, I'd suggest starting with Microsoft. There, they list a bunch of partners that offer up-to-date training. If you want online, Pluralsight...
"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
July 11, 2022 at 12:12 pm
What did you do?
Just so someone who finds your question also knows the answer.
"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
July 7, 2022 at 2:58 pm
If it makes you feel better 19 (in beta) isn't installing very quickly either.
"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
July 7, 2022 at 2:57 pm
Viewing 15 posts - 826 through 840 (of 22,224 total)