Viewing 15 posts - 541 through 555 (of 22,219 total)
Nope. If it's already running, you can't retroactively start collecting the data necessary for a plan with runtime statistics.
However, on SQL Server 2019 or greater and Azure SQL Database, 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
March 2, 2023 at 2:49 pm
Yeesh. Your team stacked up a bunch of jenga blocks awfully high. Have fun playing.
"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
March 1, 2023 at 7:51 pm
As to letting anyone edit them, I'd build a small app for it. No sense in exposing more than you need 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
March 1, 2023 at 6:36 pm
Just that, as with anything, I'm sure there's a tipping point. "3 extended properties, no big deal, 300, 3000000, something, big deal". I honestly don't know how many zeroes 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
March 1, 2023 at 6:35 pm
I don't understand why you would have indexes (apart from maybe a clustered one) on a table with only a few rows?
Total agreement, but this one that Sam will...
"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
March 1, 2023 at 5:12 pm
I assume there's a point at which extended properties will cause an issue, but I'm not aware of anyone that has hit it using the things in a standard way....
"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
March 1, 2023 at 1:20 pm
Everything Jeff said.
We've covered this in multiple posts. Capture query metrics, I'd go with batches & procedure calls, not individual statements at this point. Capture deadlocks (Extended Events, don't listen...
"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
March 1, 2023 at 12:59 pm
It can, yes. Ghost cleanup can also block you.
The vendor can't leave this with you. You can't change the code, and the code needs to be changed. You also can't,...
"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
February 28, 2023 at 4:20 pm
Yes. Its a small table. Question is , when there is 0 rows in the table, and when we say SELECT * FROM <Tname> , why SQL Server 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
February 28, 2023 at 3:43 pm
So, yeah, about what I expected. A clustered index scan and nothing else.
So, your #1 problem query is SELECT * from a table with two rows in it?
Dude, go home....
"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
February 28, 2023 at 3:24 pm
For now, rebuilding all the indexes on the tables every 1 hour is giving some relief. query returns in few milli secs.
but... why? Two rows or sometimes empty? Honestly,...
"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
February 28, 2023 at 3:17 pm
I'm afraid I don't understand. What's that? It's a picture of some data from a query running SELECT * returning 2 rows. I'm confused.
"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
February 28, 2023 at 2:39 pm
What do the execution plans look like? What do the queries look like. There's not a 'run faster' switch that can be flipped here. Without some understanding of the behaviors...
"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
February 28, 2023 at 1:13 pm
If a FK or a trigger is involved i hope , there should be some kindly of error thrown?.
Not if it's just processing all the validations, scanning tables looking...
"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
February 28, 2023 at 12:58 pm
I read through the interview questions at the link, and yeah, I'd say those are somewhat tough questions. I've been doing this for 30+ years. I've written a few books....
"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
February 24, 2023 at 12:05 pm
Viewing 15 posts - 541 through 555 (of 22,219 total)