Viewing 15 posts - 811 through 825 (of 22,227 total)
Also, you sometimes see this kind of thing when thresholds are crossed such that the row counts change and different execution plans get generated. Over time, statistics and data distribution...
"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
September 13, 2022 at 12:36 pm
Take a look above at the "Stairways" menu choice. Inside there are tons of classes, including several on T-SQL fundamentals. They're 100% free. Go 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
September 13, 2022 at 12:33 pm
Just for clarification, each execution plan is only, ever, for a given query. Sure, a batch or procedure might have 50 queries, but there will be 50, individual, execution plans...
"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
September 13, 2022 at 12:31 pm
Is your user in the public role? If not, that could be it. That's required to access sys.dm_os_host_info per the documentation.
"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
September 13, 2022 at 12:29 pm
Ken is correct, query store only works on the primary prior to 2022.
Yeah, query store is database by database, only, even in 2022. So each database gets it's own store....
"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
September 13, 2022 at 12:26 pm
Also, Azure SQL Database is backed up for you. Further, there is no capability for you to do a traditional backup. Instead, you can create what's called 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
September 9, 2022 at 8:31 pm
I don't have a degree. Will I get the degree if I answer the question?
"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
September 9, 2022 at 7:08 pm
Please, no, don't start throwing hints all over it. Instead, focus on getting the execution plan and understanding what it is telling about how the query is behaving and how...
"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
September 9, 2022 at 7:07 pm
Also, Azure SQL Database is backed up for you. Further, there is no capability for you to do a traditional backup. Instead, you can create what's called a bacpac, 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
September 9, 2022 at 7:02 pm
I guess you need to ask yourself, how likely is it that you're going to go back to Week 17 of Year 6 in your 10 years of weekly backups?...
"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
September 9, 2022 at 6:57 pm
You can do exactly that for the databases. However, there will be the downtime of copying them over to the new server prior to attaching them.
However, the system stuff, logins,...
"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
September 7, 2022 at 4:25 pm
I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". 😀
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
September 7, 2022 at 3:25 pm
Hey all!
Back from sabbatical. Happy to see we're still talking deadlocks. Ha!
"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
September 6, 2022 at 11:35 am
I was just troubleshooting a similar issue to find the difference was the default database assigned to the user accounts. After getting query execution plans for both logins (which...
"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
August 17, 2022 at 2:04 pm
...do you rely only on objects in LINQ to "join" tables?
Yes. You will be hard pressed to find join in any EF tutorials; other than just the places...
"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
August 16, 2022 at 2:14 pm
Viewing 15 posts - 811 through 825 (of 22,227 total)