Viewing 15 posts - 12,976 through 12,990 (of 22,224 total)
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
Ninja's_RGR'us (3/21/2011)
GilaMonster (3/21/2011)
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:37 am
Let's see, movies, games, surfing the web...
For work?
Not much. I've done some writing on it because I have the ZaggMate keyboard. I take notes on it. I use it 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
March 21, 2011 at 6:22 am
Whether the table is large or not, if you have the write indexes on it, you should be able to retrieve your data easily. You might want to consider partitioning...
"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 5:56 am
Viewing 15 posts - 12,976 through 12,990 (of 22,224 total)