Viewing 15 posts - 1,096 through 1,110 (of 22,227 total)
Actually it sounds like you could put a tally table, or a table of numbers to work and simply pass in your 1-10 tanks (which really does sound like 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
November 18, 2021 at 2:13 pm
Also, don't set the max of SQL Server to max of the system. You have to leave room for the operating system to have memory as well. While you can...
"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 18, 2021 at 2:07 pm
Without a WHERE clause, no filtering occurs, so it goes to the cluster to pull stuff together. If you want to eliminate the sort, you can create an index on...
"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 17, 2021 at 1:25 pm
Thank you everyone. I have been saving the files to a folder. it works for me because I only have a few queries. I am so used 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
November 15, 2021 at 10:22 pm
If you do this a lot, create a stored procedure or maybe a view. If nothing else, have the query in a file that you can open & run. 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
November 15, 2021 at 2:17 pm
Welcome to the party.
Pretty much what Jeff says (btw, that's a good mantra around here).
SQL Server's principal tool, SQL Server Management Studio (SSMS), has a thing called a project. I...
"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 15, 2021 at 2:15 pm
Along with what Grant has stated and since they said it did "regular" SQL Backups, have them do a test restore using native tools only to prove...
"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 10, 2021 at 3:08 pm
Yeah, go get that lottery ticket now.
Happy to hear it all worked out. As Jeff says, get going on those backups. In addition to all his great info, let add...
"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 8, 2021 at 2:00 pm
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
Viewing 15 posts - 1,096 through 1,110 (of 22,227 total)