Viewing 15 posts - 2,821 through 2,835 (of 22,219 total)
Tac11 - Wednesday, December 19, 2018 10:04 AMThanks Grant, Any particular script do you suggest for compilation/recompilation trouble shoot?
Nope. Any script will compile or...
"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
December 19, 2018 at 1:16 pm
Change the query. Add the columns to the GROUP BY clause, or make it a sub-select or...
"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
December 19, 2018 at 1:15 pm
"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
December 19, 2018 at 5:23 am
If you're using Azure SQL Database I'd look into the COPY DATABASE command in Powershell. That's going to let you capture a quiet copy of the database and then 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
December 19, 2018 at 4:21 am
Look through the system views and you ought to be able to figure it all out. sys.dm_exec_query_stats has a number of values like sql_handle for finding statements and the plan_handle...
"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
December 19, 2018 at 4:15 am
So, automatically killing long running queries or queries that are blocking is a very bad idea. Can it be done? Certainly. There are a number of ways you could do...
"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
December 18, 2018 at 6:28 am
Or, since we're talking 2016, there's always:
ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE CACHE
However, same rules apply. Don't do this in production.
You can also try using...
"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
December 18, 2018 at 6:10 am
"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
December 17, 2018 at 1:09 pm
If all the data has to be returned all the time, the only way to speed that up is to spend lots and lots of money on hardware. There 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
December 17, 2018 at 5:42 am
You have an 8gb server (half my laptop by the way) and a query that moves ALL the data. How big is this database? If you're moving all 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
December 17, 2018 at 5:14 am
It would be a lot easier to give you detailed answers with example queries, structure, and execution plans for the existing queries you're running. Otherwise, we're making guesses here. "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 17, 2018 at 5:11 am
Are you in an Azure Virtual Machine (in which case, it's just Windows & SQL Server and should behave the same as a local instance of SQL Server) or are...
"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
December 17, 2018 at 5:07 am
100% agreement with Joe. You should be following best practices and writing the code correctly including object ownership. However, Azure SQL Database is SQL Server. If you have a valid...
"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
December 14, 2018 at 1:43 am
The way I'd do it is to create a copy of the production database, then export that to a BACPAC. The reason to do two steps is because the BACPAC...
"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
December 14, 2018 at 1:41 am
Agree with everything Lynn said. Emphasizing, this: "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 13, 2018 at 2:04 am
Viewing 15 posts - 2,821 through 2,835 (of 22,219 total)