Viewing 15 posts - 556 through 570 (of 22,232 total)
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
Are any thredizens going to be in Atlanta for SQL Saturday BI Edition???
Nope. But I am in Austin for SQL Saturday here.
"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 2:59 am
Just wanted to say thanks on this again, Grant. Work has given me the green light for SQLBits; it's a bit (no pun intended) last minute though so all...
"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 22, 2023 at 6:47 pm
Viewing 15 posts - 556 through 570 (of 22,232 total)