Viewing 15 posts - 4,411 through 4,425 (of 22,227 total)
ScottPletcher (9/22/2016)
Also, be aware that some plans are never cached at all, for example, a trivial plan to satisfy "select * from table_name".
Actually, trivial plans are stored in cache. 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
September 22, 2016 at 11:04 am
SSIS is probably what most people use. You could absolutely do all this using Powershell though.
"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 22, 2016 at 8:27 am
You may want to also look to sys.dm_exec_query_stats. The DMV you're referencing, sys.dm_exec_procedure_stats, only has statistics for stored procedures and parameterized queries. Any ad hoc or dynamic queries are in...
"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 22, 2016 at 6:41 am
Table statistics are there because at least one query has referenced a column in such a way that the statistic was needed to determine the execution plan. If those statistics...
"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 22, 2016 at 6:38 am
It's likely that either or both of those queries are part of a larger batch that has other parts that are still holding resources. However, as Gail says, no way...
"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 22, 2016 at 6:36 am
jasona.work (9/21/2016)
"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 22, 2016 at 6:27 am
The bigger concern is going to be the lowest common denominator T-SQL that the API is going to generate. About 90% or so will be fine. That last 10% will...
"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 21, 2016 at 10:12 am
No more than entry level. Most of the time, hiring a DBA from outside the company, you're looking for someone with experience, not just a certificate. Within an organization people...
"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 21, 2016 at 6:35 am
I suspect this is an extension on the concepts around an ORM (Object-Relational Mapping) tool. Instead of writing T-SQL, you just access the API and the API generates any and...
"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 21, 2016 at 6:32 am
I had this exact discussion with Adam Machanic once. We came down on the side, apart from index maintenance and storage (and we're ignoring some pretty big issues), as far...
"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 20, 2016 at 9:46 am
CELKO (9/19/2016)
"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 20, 2016 at 6:01 am
I'm not completely sure I understand the question.
You're saying that you use local variables instead of parameters?
What happens with this is that you are taking away the optimizers ability...
"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 20, 2016 at 5:59 am
That is a big number. Usually, but not always, that would indicate that the statistics are out of date or incorrect.
"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 19, 2016 at 7:38 pm
It's the table valued function, FullTextMatch. It says the estimated cost is zero, but I wouldn't believe that at all.
"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 19, 2016 at 12:43 pm
Can you post the execution plan? Save the .sqlplan file, not a picture. We need to be able to see the properties.
"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 19, 2016 at 11:28 am
Viewing 15 posts - 4,411 through 4,425 (of 22,227 total)