Viewing 15 posts - 1,351 through 1,365 (of 22,224 total)
yeah, it's down to whether or not the app name is included in the connection. If it's not there, it's probably not possible to tell where any given query 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
April 30, 2021 at 1:46 pm
If your number one wait statistic is anything except IO_LATCH*, don't mess with memory optimized tables. OK, maybe, MAYBE, for some table variables, they do pretty cool things there. However,...
"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, 2021 at 3:11 pm
Hey Tom!
So, for Managed Instance, and for Azure SQL Database, while Microsoft is handling things like consistency checks and backups, you are responsible for what goes on inside the database....
"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, 2021 at 3:02 pm
Oh, I won't be surprised if they change the licensing model. But I'm positive that development on the product is going to continue. Each release puts another 10 years, minimum,...
"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 22, 2021 at 11:56 am
I'd go one farther. Set up database security so that you have groups. Grant security to the groups. Add/remove logins or groups of logins with the groups. It makes security...
"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 22, 2021 at 11:22 am
This one is all about opinion, so, take with a grain of salt the size of a house.
You're being a little bit paranoid. SQL Server is one of the most...
"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 22, 2021 at 11:19 am
Agreement with what everyone else added.
"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 21, 2021 at 6:12 pm
Heh... I agree with Grant on logical execution being left to right and data flow being right to left and both being top to bottom (except on super-umbra-red...
"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 21, 2021 at 6:11 pm
Thank you Grant, actually if you have the power you can just delete that, I didn't redact parts of the screenshot I should have. Reporting it was 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
April 21, 2021 at 6:09 pm
I'm a little confused. You keep talking about servers and server specs. However, you also said you were using Azure SQL Database. That doesn't involve servers. So... which is 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 21, 2021 at 11:03 am
OK. This is a fun one.
Execution plans are logically executed from left to right, and roughly, top to bottom. You can validate I'm right about this by looking at 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
April 21, 2021 at 11:00 am
Yep. Without the rest of the error message, I can't even hazard a guess. Jeff is probably right (says Grant all the time).
"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 21, 2021 at 10:46 am
Ha! Clearly I type slowly and/or too much. Agreement with @Ant-Green. +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 21, 2021 at 10:44 am
You're in a bit of a tough spot, not having a network. However, probably, your best bet would be to use Azure SQL Database (or AWS RDS SQL Server,...
"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 21, 2021 at 10:42 am
All the votes for Johan's solution with Extended Events. #TeamXE
Also, I unspammed TangoVictor's first post, not noticing the second. Not sure why that happened. I put it back to spam...
"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 21, 2021 at 10:34 am
Viewing 15 posts - 1,351 through 1,365 (of 22,224 total)