Viewing 15 posts - 12,976 through 12,990 (of 22,227 total)
sppdba (3/22/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
March 22, 2011 at 3:41 pm
Stefan Krzywicki (3/22/2011)
Grant Fritchey (3/22/2011)
Brandie Tarvin (3/22/2011)
Oh, hey, completely non-SQL related link:If you like superheroes, you will like "Grayson" (They created this trailer with an 18,000 dollar budget).
Makes me...
"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
March 22, 2011 at 1:46 pm
It depends on the DMV. Many of the most interesting ones about query performance are completely dependent on the cache. Others work off the last time SQL Server was restarted...
"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
March 22, 2011 at 1:42 pm
Brandie Tarvin (3/22/2011)
Oh, hey, completely non-SQL related link:If you like superheroes, you will like "Grayson" (They created this trailer with an 18,000 dollar budget).
Makes me miss film making. I...
"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
March 22, 2011 at 1:38 pm
GilaMonster (3/22/2011)
Brandie Tarvin (3/22/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
March 22, 2011 at 1:20 pm
Pei Zhu-415513 (3/22/2011)
Thanks. In other words, if it ran successfully, the production is clear off the corruption as of the time backup took place. But if it failed, you wouldn't...
"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
March 22, 2011 at 11:28 am
chandan_jha18 (3/22/2011)
Grant Fritchey (3/22/2011)
You're getting a scan on one table, overall, the system...
"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
March 22, 2011 at 6:21 am
It's hard to do more than suggest general approaches based on the information provided.
The one concern I would have with the existing structure: what do the cluster indexes look like?...
"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
March 22, 2011 at 5:19 am
Looking at the code, this is a query against a view. What does the view code look like?
You're getting a scan on one table, overall, the system is processing 35000...
"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
March 22, 2011 at 5:10 am
Just so you know, nesting views adds considerably to the work the optimizer has to do to unpack the views to try to get to an optimal execution plan. When...
"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
March 22, 2011 at 4:59 am
Roy Ernest (3/21/2011)
Have anyone heard of Hampton Inn in Plymouth? If so what do you think?
She is crying when I told her that Duxbury 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
March 21, 2011 at 3:27 pm
Roy Ernest (3/21/2011)
Stefan Krzywicki (3/21/2011)
Roy Ernest (3/21/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
March 21, 2011 at 11:50 am
I'm near Boston.
"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
March 21, 2011 at 9:58 am
Ninja's_RGR'us (3/21/2011)
Grant Fritchey (3/21/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
March 21, 2011 at 6:43 am
It's not that kind of site.
"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
March 21, 2011 at 6:38 am
Viewing 15 posts - 12,976 through 12,990 (of 22,227 total)