Viewing 15 posts - 1,096 through 1,110 (of 22,219 total)
Are you sure the execution plans are identical? Did you run a compare on them to validate that? Just because they look the same, doesn't mean they are 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
November 5, 2021 at 12:25 pm
Deny is a trump over all other security. So, you may have a complex set up where a given user, because they're in a group, has access to a table...
"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 5, 2021 at 12:14 pm
Well, this is interesting. SQL 2022. No more parameter sniffing?
ALL THE TESTING!!!!
"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 2, 2021 at 11:06 pm
Strong suggestion, don't store the response time. Store the start and stop times and then calculate the response times when you retrieve the data.
I have to ask, what...
"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 1, 2021 at 2:43 pm
The problem is very likely in the queries, as has been stated. You can capture execution plans from Azure SQL Database. You can do it pretty much all 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
November 1, 2021 at 11:56 am
Not to mention, learning how to present will help you at work, presenting a solution to the boss, teaching the team how to do stuff. It's a VERY transferable skill....
"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 1, 2021 at 11:47 am
Strong suggestion, don't store the response time. Store the start and stop times and then calculate the response times when you retrieve the 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
November 1, 2021 at 11:44 am
That's a convoluted way to go about a data transfer. Why do you have to use XML? Why do you have to use triggers? SQL Server has built in mechanisms...
"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 1, 2021 at 11:43 am
I 100% agree with grant.
So you think that's one ugly dude too.
"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 27, 2021 at 9:24 pm
yeah, on the one hand, they make it easy. On the other hand, which damned one is best? I'm not sure there's a perfect 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
October 27, 2021 at 2:18 pm
There are like 20 different scheduling tools in Azure. Pick one. Any one. Use 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
October 27, 2021 at 1:56 pm
Learn how to do this through T-SQL. It's vastly superior, and ultimately, believe it or not, much easier.
It's going to be really hard for us to troubleshoot through screen shots....
"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 27, 2021 at 1:54 pm
That dude in the vest is seriously ugly.
I've spent the last 20 months doing online events. On one level, they're helping people who couldn't/wouldn't ever attend in-person events, which 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
October 27, 2021 at 1:52 pm
Try to see if you can export the data, not back it up. Chances are you won't be able to, but try. And, if you get an error, read 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
October 26, 2021 at 2:41 pm
Man, that's asking for trouble, but...
You just need to use sp_executesql. Query the table to get the string. Load that into a variable. Follow the link to see 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
October 26, 2021 at 2:38 pm
Viewing 15 posts - 1,096 through 1,110 (of 22,219 total)