Viewing 15 posts - 256 through 270 (of 22,227 total)
Thank you Grant for bringing up the important subject of self care. There are numerous youtube videos that you can find on the subject. But they all seem 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
May 8, 2024 at 5:57 pm
And, it looks like the code is hitting this table, [CoreV2].[HCM].[Employee_Info_Master].[EmployeeInfoMaster_List_Name_Top] [emp_CA], over and over again. You shouldn't have to reference the same table repeatedly unless you're getting different 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
May 6, 2024 at 2:47 pm
Woof!
You have a bunch of plan affecting conversion warnings. I'd look to those as a first step. Nesting views, having a view that calls other views which joins to views,...
"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
May 6, 2024 at 2:42 pm
Are you getting deadlocks, with a deadlock victim, errors and all that? Or, are you seeing excessive blocking and long wait times on queries, which is absolutely not the same...
"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
May 6, 2024 at 2:28 pm
Thanks everyone for your stories. And yeah, none of this is necessarily easy or doable all the time. However, through lots of personal experience, I believe this stuff is important.
"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
May 6, 2024 at 12:10 pm
Yep. What Perry says. Also, test enabling causality tracking to be able to correlate queries to the stats updates.
"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
May 3, 2024 at 2:32 pm
Generally, just measuring performance of the hardware under no load, is a bit of a waste of time. You're just checking, mainly, that the people who sold it to you...
"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
April 29, 2024 at 1:08 pm
That is a very long time for a rollback.
So, you did experience data loss. The transaction that was rolled back, whatever it was doing that took 30 hours to undo...
"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
April 29, 2024 at 1:02 pm
My last company did a lot of engineering and testing. One thing they found is that most computer hardware failures occurred during startup. Evidently computers can just run forever, but...
"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
April 26, 2024 at 12:50 pm
Perry and David, you know I agree.
"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
April 26, 2024 at 12:21 pm
What about the appliance argument? Namely, there's an application running on SQL Server 2008 & Windows Server 2003 that runs purely in-house and is not connected to the Internet....
"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
April 26, 2024 at 12:19 pm
Reading these posts makes me feel better about only having SQL Server 2016 (and an exit plan for it) and procrastinating over upgrading my Windows 8.1 tablet because it...
"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
April 26, 2024 at 12:16 pm
The beauty of code, over toilets, is that we can, if we choose, improve the code. Tougher to do with toilets.
"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
April 24, 2024 at 11:15 am
I uploaded your picture to ChatGPT 4 and asked it to: "Write a SQL Server create table (table name: XXXRE60P) and insert script for this, make sure you include...
"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
April 11, 2024 at 2:59 pm
we need a script that generates your data & structure.
...and how do I do that? I don't mind taking the time, I just don't even know what step 1...
"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
April 11, 2024 at 2:39 pm
Viewing 15 posts - 256 through 270 (of 22,227 total)