Viewing 15 posts - 511 through 525 (of 22,224 total)
That's because based on your basic data set, no combination of server and database has a count above one. Put a second instance of Server4 db2 in there and 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
March 28, 2023 at 11:54 am
I'm sorry. I guess I completely misread that. I tracked down the DOP_FEEDBACK page, and yeah, it's not in Azure. Interesting.
Looking into it some more, the basic batch &...
"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 24, 2023 at 6:13 pm
You can use sys.dm_db_index_usage_stats to see the information on how an index is behaving. I assume you're using that. However, as you find, that info resets for a number of...
"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 23, 2023 at 11:40 am
In fact, the Microsoft documentation says just the opposite: "All IQP features are available in Azure SQL Managed Instance and Azure SQL Database." You can read about it here.
So,...
"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 23, 2023 at 11:33 am
And get backups of your databases and test them by restoring them somewhere. Don't just take a backup. Test a restore too. It demonstrates that yes, the backup is good,...
"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 22, 2023 at 12:40 pm
Yep, looks right to me too.
"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 22, 2023 at 12:39 pm
As currently configured, to move an Azure SQL Database to on-premises, unless you're setting up a failover group (which, if you're using Managed Instance can be done), the only choice...
"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 21, 2023 at 12:58 pm
Whatever will make the behavior the same. I can't tell from where I sit.
"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 20, 2023 at 3:43 pm
So, when we talk about comparing performance between something like a UAT system and a production system, we've got to get more specific.
Are you saying, for a given query, against...
"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 20, 2023 at 2:53 pm
For the first execution of a query, you only store a plan stub (basically a hash for the query, plan & settings affecting the plan) instead of a plan. That's...
"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 20, 2023 at 2:45 pm
Security. Your login has different privs than whatever process you're running under through the server.
"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 20, 2023 at 2:40 pm
Thanks! Glad to hear it.
"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 20, 2023 at 1:05 pm
There's some great stuff. Thanks for sharing.
"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 16, 2023 at 5:50 am
We get a bunch of tasks/requests to run t-sql scripts to update views or stored procs or bad data.
Does anyone know of a server product that can automate...
"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 14, 2023 at 3:44 pm
If you have the database registered as a data tier application, there's a way to do a test run to generate a script that would be run. You could then...
"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 14, 2023 at 12:15 pm
Viewing 15 posts - 511 through 525 (of 22,224 total)