Viewing 15 posts - 11,776 through 11,790 (of 22,219 total)
GilaMonster (9/29/2011)
Evil Kraig F (9/29/2011)
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
Awesome...
"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 29, 2011 at 1:00 pm
Evil Kraig F (9/29/2011)
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
Awesome Gail,...
"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 29, 2011 at 12:59 pm
But wait, if your CPU is maxing out, what makes you think it's memory pressure? I can see I/O issues from memory pressure as more and more stuff is cached...
"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 29, 2011 at 5:58 am
Ooops. Misread that question. Gail is right. It's not stored twice. I just meant it's stored anyway... sorry about that.
"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 29, 2011 at 5:56 am
GilaMonster (9/29/2011)
Grant Fritchey (9/29/2011)
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
Well done...
"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 29, 2011 at 5:54 am
sys.dm_exec_query_stats and sys.dm_exec_procedure_stats are aggregates showing all the times that the query has been called. No way to link it to an individual call, as Gail says.
"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 29, 2011 at 4:53 am
Yes. You're right. The cluster key is stored as part of non-clustered indexes 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 29, 2011 at 4:51 am
islandwino (9/28/2011)
Grant Fritchey (9/28/2011)
I ask because I'm the product...
"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 29, 2011 at 4:48 am
setvij (9/28/2011)
"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 29, 2011 at 4:45 am
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
Well done Gail. I have...
"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 29, 2011 at 4:42 am
The 3rd party tools do stuff that the native doesn't or they do stuff the native does better or faster or easier.
I ask because I'm the product evangelist for Red...
"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 28, 2011 at 8:48 pm
Assuming updates to different partitions, no you shouldn't see blocking while those updates are occurring. You can still block within a partition though.
As to your second question, no, 1/2 a...
"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 28, 2011 at 2:46 pm
Assuming I understand what you're asking, make query A into a sub-select that acts as a table for query B. I can't vouch for performance, but that's how I'd start....
"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 28, 2011 at 2:43 pm
Does that software run a SQL Backup or is it some custom binary? If it's custom, I'd ask for an immediate test of the restore to see that your databases...
"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 28, 2011 at 2:40 pm
Here's the predicate from the properties (don't use the tool tip, not enough info there).
[IARTS].[dbo].[Cust_Ident_Type].[Effective_DT] as [CIT].[Effective_DT]<=[@GetDate] AND ([IARTS].[dbo].[Cust_Ident_Type].[End_DT] as [CIT].[End_DT] IS NULL OR [IARTS].[dbo].[Cust_Ident_Type].[End_DT] as [CIT].[End_DT]>[@GetDate])
The two columns referenced...
"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 28, 2011 at 11:01 am
Viewing 15 posts - 11,776 through 11,790 (of 22,219 total)