Viewing 15 posts - 316 through 330 (of 22,224 total)
To be sure, I'd need to see the query and an execution plan. Also, the collation you're using could affect this. However, in general, no, that shouldn't be a concern....
"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 17, 2024 at 1:18 pm
Grant, loved the post. I remember coming out of college and interviewing for my first job. I was interview by a 50-something year old who was still a software...
"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 16, 2024 at 9:04 pm
Communication is key. What you need is honest feedback, not soft-soap feedback.
Not dismissing any of what you wrote, all sounds great honestly, but this bit, oh yes!!
"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:50 pm
I like the way you put it, Grant; "Play to your strengths". I will sometimes daydream about being a CEO because of the money they make, but I think...
"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:48 pm
A nice read for a Saturday morning. I remember back when I started in my current department and I thought "one day, I want to be a manager like...
"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:46 pm
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
Viewing 15 posts - 316 through 330 (of 22,224 total)