Viewing 15 posts - 11,821 through 11,835 (of 22,219 total)
GSquared (9/23/2011)
Grant Fritchey (9/23/2011)
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Based on a long history of reading...
"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 23, 2011 at 11:06 am
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Based on a long history of reading about muck-raking journalism...
"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 23, 2011 at 11:00 am
GilaMonster (9/22/2011)
SQL Server MVP Deep Dives 2 will soon be available for pre-order and early access via Manning publishers: http://www.manning.com/delaney/
Chapter 8: "The how and why of Page Restores", Grant...
"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 22, 2011 at 3:10 pm
jcrawf02 (9/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
September 22, 2011 at 10:44 am
Ninja's_RGR'us (9/22/2011)
Kiara (9/22/2011)
GilaMonster (9/22/2011)
Jim Murphy (9/21/2011)
And where's Gail? Is she not keeping you guys in line?
Doing the final checks and tweaks on Jonathan's book.
Keep this lot in line? How...
"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 22, 2011 at 6:24 am
forsqlserver (9/22/2011)
Nice Grant...But this is giving the error of invalid arguments...means some invalid...how does it related with plan...
Sorry, you have to be more clear what "this" is.
This works fine...
"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 22, 2011 at 4:43 am
Waits stats will show you what processes are waiting on, but you won't see what's up with that single request. Instead, I'd suggest using Dynamic Management Objects (DMOs). You can...
"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 22, 2011 at 4:30 am
Scripting would be the only way I'd consider it. Even if you just backup & restore msdb to the other server (which won't work), you still need to deal with...
"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 22, 2011 at 4:20 am
Assuming you want to minimize downtime, you might want to look into setting up log shipping so that you can get the TB worth of data moved over and only...
"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 22, 2011 at 4:17 am
It really depends on the size of the company and your disaster recovery plan. My former employer was rather large. We had an offsite facility, several hundred miles away 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 22, 2011 at 4:15 am
Sorry for you & your spouses loss Jim.
"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 21, 2011 at 11:29 am
Yeah, absolutely. That's the same technology at work in Virtual Restore. It reads the backup like it was a database.
"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 21, 2011 at 5:42 am
Nah, no points, don't sweat it.
Basically, you're hitting a situation that's not far removed from parameter sniffing. Your query is better off with an average, sampled, set of values, rather...
"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 20, 2011 at 8:34 pm
The thing is, both plans show as having done FULL optimization, so these aren't terribly complex plans. But the costs are very high, and the table scans and RID lookups...
"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 20, 2011 at 11:14 am
You've got a GIANT disparity in statistics between the two data sets. One estimates 3.7 million, the other estimates 174. Right there is the main point of difference that 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
September 20, 2011 at 11:01 am
Viewing 15 posts - 11,821 through 11,835 (of 22,219 total)