Viewing 15 posts - 4,396 through 4,410 (of 22,219 total)
Thanks everyone for the feedback. I was hoping someone would come in and argue in favor of hiding information since it sometimes seems to be considered a valid position.
"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 26, 2016 at 6:09 am
call.copse (9/26/2016)
"If you really can't fix the problem then,"Can't fix the problem? Does this situation really occur? Everything is fixable one way or another...
If the issue is beyond someone's capabilities...
"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 26, 2016 at 6:08 am
I would suggest setting up an Extended Events blocked process report. Here's a blog post[/url] on how to do it. You can also query sys.dm_exec_requests when the blocking is occurring...
"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 23, 2016 at 12:35 pm
If I can afford a full scan, that's better. Absolutely.
"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 23, 2016 at 10:31 am
Mike Scalise (9/23/2016)
So something like:
1) DBCC CHECKDB
2) Update 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 23, 2016 at 9:01 am
What was it? A startup trigger or something else?
"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 1:00 pm
Take a look at the SEQUENCE object. That's one way to have this without using IDENTITY. Plus, IDENTITY just using SEQUENCE under the covers anyway.
"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 12:59 pm
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
Viewing 15 posts - 4,396 through 4,410 (of 22,219 total)