Viewing 15 posts - 11,626 through 11,640 (of 22,224 total)
Lexa (11/22/2011)
Grant Fritchey (11/22/2011)
Lexa (11/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
November 22, 2011 at 2:23 pm
Stefan Krzywicki (11/22/2011)
Kit G (11/22/2011)
bitbucket-25253 (11/22/2011)
Ah for real problems try Cleveland and its suburbs ... Columbus is pleasant compared to Clevland ...
Cleveland... isn't that where people go when they die?...
"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
November 22, 2011 at 12:23 pm
Lexa (11/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
November 22, 2011 at 5:52 am
Ninja's_RGR'us (11/22/2011)
What do you guys think of this as a first house?http://passerelle.centris.ca/Redirect2.aspx?CodeDest=I2V&NoMls=MT8619554&Source=
Looks nice. Right off a lake, but still on the hill, so no flooding, cool.
"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
November 22, 2011 at 5:49 am
Sounds good. If you hit technical issues, you know where to find 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
November 22, 2011 at 4:36 am
You're comparing calculated values to calculated values. Indexes are no longer a part of the equation. It's nothing but scans. That's a guaranteed performance degradation as more and more rows...
"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
November 21, 2011 at 2:52 pm
GilaMonster (11/21/2011)
GSquared (11/21/2011)
It must be DBA season somewhere.Open season on DBAs??? *fetches bow*
*fetches rifle* And not the bolt-action one either.
"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
November 21, 2011 at 2:22 pm
Gail's articles will get you started. When you need more, please consider my book (in the signature line).
"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
November 21, 2011 at 11:16 am
1 & 2 are in the Books Online.
3. Yes. For more details see the Books Online.
4. There is an error log associated with the Agent. You can get errors there...
"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
November 21, 2011 at 11:15 am
A differential is the sum total of all changes since the last full backup. When did you last take a full backup?
"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
November 21, 2011 at 11:14 am
It's as the Ninja & Gail says, a plan is neither good nor bad, per se. It's the statistics, the structure, and your query, that drive what kind of plan...
"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
November 21, 2011 at 11:00 am
goofy2sql (11/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
November 21, 2011 at 10:57 am
Jack Corbett (11/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
November 21, 2011 at 9:06 am
ChrisM@Work (11/21/2011)
Grant Fritchey (11/21/2011)
Wibble.It won't work without the knickers and pencils;-)
Yeah, got those here.
Wibble
"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
November 21, 2011 at 8:18 am
CPU & IO pressure are different. I'd need a lot more information to make even vague suggestions.
"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
November 21, 2011 at 8:17 am
Viewing 15 posts - 11,626 through 11,640 (of 22,224 total)