Viewing 15 posts - 976 through 990 (of 22,224 total)
Oh, same query, but not just a single instance of the query. Yeah, totally different. I understood you meant that only the one process and one query was involved. Instead,...
"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, 2022 at 5:23 pm
Data.
As data changes, so does behavior. A query that was fine for 10k rows isn't for 10million. Check the execution plans. Look at row estimates there. Compare them to reality....
"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, 2022 at 4:44 pm
There are always exceptions to everything, but speaking in general terms, you'll be better off letting SQL Server perform an update through the UPDATE process rather than deleting existing 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
February 22, 2022 at 4:00 pm
Let's say you're a small organization. You don't have a massive IT budget. Yet, you want a database. Do you now have to hire someone to set up servers, an...
"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, 2022 at 3:53 pm
Be real cautious about fixing deadlocks using table lock hints. It may fix the deadlock, but can cause other performance hits. Testing is your friend.
Likely, it's a parallelism deadlock. You'll...
"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, 2022 at 3:44 pm
When I see a sudden change in behavior like this, first is checking all the servers & os's, etc., for changes. A new patch on the SAN or on 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
February 22, 2022 at 3:41 pm
Yep. Formatting is best done in the client app. Always.
"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 11, 2022 at 1:51 pm
Thanks Grant. I presume there are sys tables for jobs and job activity. Not sure if I then do sp_stop_job or KILL process.
I suspect either will work. Testing is your...
"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 10, 2022 at 2:54 pm
Sorry, Steve, I clicked "report" in stead of quote 🙁
Closing a post after 1 year of no responses seems fair to me.
I fixed it.
And yeah, I agree. After a...
"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 10, 2022 at 2:41 pm
It really does depend on the error, but you should look at the system_health extended event session. You can get errors there. Also, you can get queries that held...
"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 10, 2022 at 2:40 pm
There's no way to do this within the query, so what you have to do instead is set up a monitoring job. Start it at the same time as 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
February 10, 2022 at 2:37 pm
Just as a straw poll, what if we had threads older than 1 year - latest post date <= dateadd (year, -1, getdate) - closed when someone tries 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
February 9, 2022 at 8:02 pm
I feel like that list is proof that Grant and Jeff are the same person, as they have exactly the same amount of subscriptions.
No.
You've got that all wrong. Jeff...
"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 9, 2022 at 6:59 pm
NVARCHAR for the win!
"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 9, 2022 at 3:40 pm
I've done database design by sitting with the developers and the business people, both. If you don't have full input, you're guessing. I really hate guessing. I get it wrong,...
"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 9, 2022 at 2:38 pm
Viewing 15 posts - 976 through 990 (of 22,224 total)