Viewing 15 posts - 316 through 330 (of 22,219 total)
Good morning Grant. First, I congratulate you on having put in 35 years in IT. You are a survivor for sure. I understand your feelings about those who 'climbed...
"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 15, 2024 at 1:44 pm
Maximize your maximums, minimize your minimums.
Love 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
January 15, 2024 at 1:43 pm
Moving this kind of data truly comes down to hardware (or service tiers if you're in the cloud). All the suggestions will help, but mostly at the margins. More memory,...
"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 4, 2024 at 1:19 pm
I'm going off what they typed. If that's true, there's the problem and solution. If not, we need to know that.
"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 2, 2024 at 4:50 pm
...currently it returns all records in the table...
We can ignore everything else for the moment.
If a query is returning everything from a table, and there is no way 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
January 2, 2024 at 4:17 pm
As far as I understand it, SQL compiles the plan before it executes.
When you use a variable, SQL compiles a plan for an unknown value.
When you use a fixed...
"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 20, 2023 at 1:26 pm
Ha! Thanks. I'll see if we can do it. We only had yesterday and today to play a little.
"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, 2023 at 5:36 am
For something like this, assuming no other objects involved, it's not a view, you're not running some kind of monitoring, then, my suggestion is as follows. You have very little...
"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 7, 2023 at 12:55 pm
This could be so many different things it's going to be hard to give you an answer. First of all, you haven't stated what you're doing. Is this a SELECT...
"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 7, 2023 at 12:27 pm
I cannot find the article referenced: "Writing SQL Server code with AI using GitHub Copilot" that is supposed to discuss how to install CoPilot. After installing per GitHub...
"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 6, 2023 at 2:28 pm
I cannot find the article referenced: "Writing SQL Server code with AI using GitHub Copilot" that is supposed to discuss how to install CoPilot. After installing per GitHub...
"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 6, 2023 at 2:27 pm
Just so you know, the only people who will see this, and maybe provide some answers, are ones who already subscribe to this thread, or find it by accident. If...
"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 5, 2023 at 12:48 pm
This situation was quite the train wreck. First blush, I kind of felt bad for the organizers. I understand the struggle to get a diverse rost put together. Then, 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
December 4, 2023 at 2:24 pm
Well, the first one is, I'm guessing, being worked on by someone, somewhere. I don't know of any though.
The second one, yeah, I can help. Redgate Software, my employer, is...
"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 1, 2023 at 2:01 pm
I'm a very firm believer in the least privilege principal. You should be barely have enough access to get the job done. However, you should have enough access to get...
"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 1, 2023 at 1:56 pm
Viewing 15 posts - 316 through 330 (of 22,219 total)