Viewing 15 posts - 6,001 through 6,015 (of 22,226 total)
Thanks for reporting back with the solution. That'll help anyone who finds your question through searches.
"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
May 29, 2015 at 2:33 pm
TheSQLGuru (5/29/2015)
Grant Fritchey (5/28/2015)
TheSQLGuru (5/28/2015)
Also, I was leery of adding OPTION (RECOMPILE) for something that runs that often.
This is SIGNIFICANTLY misguided, IMHO! I will jump through EXTRAORDINARY hoops these...
"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
May 29, 2015 at 2:32 pm
Lynn Pettis (5/29/2015)
< rant >
I am still amazed at how many people have to...
"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
May 29, 2015 at 2:30 pm
I can't honestly say the number of times I've seen this go badly. Views calling other views that are joined to views which contain other nested views... It feels 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
May 29, 2015 at 2:17 pm
GilaMonster (5/29/2015)
rajeshjaiswalraj (5/29/2015)
Where DBCC or DMV will store. What its working.
DMVs don't store data, they're views into SQL's internal memory structures mostly, or database structures.
DBCC statements are very varied 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
May 29, 2015 at 6:32 am
In general practice, there's little distinction between Dynamic Management Views and Dynamic Management Functions. Most of the time they're all referred to as DMVs collectively. DBCC now means Database Console...
"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
May 29, 2015 at 3:36 am
TheSQLGuru (5/28/2015)
Also, I was leery of adding OPTION (RECOMPILE) for something that runs that often.
This is SIGNIFICANTLY misguided, IMHO! I will jump through EXTRAORDINARY hoops these days to trade...
"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
May 28, 2015 at 7:43 pm
Well, you probably use some sort of standard for the file name I assume. Build that standard into your RESTORE statement. You'll probably have to use ad hoc T-SQL, but...
"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
May 28, 2015 at 7:41 pm
BL0B_EATER (5/28/2015)
"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
May 28, 2015 at 6:58 am
I actually got this right after thinking about it, but I think Hugo is accurate in what he's saying.
"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
May 28, 2015 at 6:12 am
sys.dm_exec_requests will show you the immediately running queries that are experiencing blocking. You can combine that with sys.dm_exec_sql_text to get the query and sys.dm_exec_query_plan to get the execution plan.
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
May 28, 2015 at 6:09 am
Brandie Tarvin (5/28/2015)
Kyrilluk (5/28/2015)
"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
May 28, 2015 at 6:05 am
Another point, if you are trying to measure the execution time, make darned sure you turn off the STATISTICS IO when you do. They can radically skew[/url] the results 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
May 28, 2015 at 6:02 am
Never been, but it's on my bucket list. I really need to schedule one and get the company to pay for 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
May 28, 2015 at 4:51 am
One other point to consider is whether or not you're using local variables in the actual code or you're using parameters. If local variables, then you're seeing averages from the...
"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
May 28, 2015 at 4:50 am
Viewing 15 posts - 6,001 through 6,015 (of 22,226 total)