Viewing 15 posts - 11,131 through 11,145 (of 22,219 total)
How are you determining that the backup is corrupt? What's the precise error?
Are you using checksum when you run the backup? If not, try running the backup using that. You'll...
"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
April 6, 2012 at 4:17 am
I've got a 600 page answer for you. It's the book down in my signature on Query Performance Tuning. Performance monitoring and tuning is a HUGE topic.
Another book you should...
"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
April 6, 2012 at 4:15 am
You shouldn't run Profiler on a production system anyway. But by that do you mean you can't run a trace script?
Since you're posting in a 2008 forum what about...
"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
April 6, 2012 at 4:10 am
I've done a number of those as in-place upgrades with no issues. I'd still recommend running the 2008R2 version of the upgrade advisor first, but other than that... I think...
"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
April 6, 2012 at 4:06 am
Seriously, that sounds like interview questions. Sorry, I'm with the others. I'm not helping 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
April 6, 2012 at 3:58 am
A CTE is a just a derived table. It's one with some unique properties in that you can refer to it more than once in the following query, but it's...
"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
April 6, 2012 at 3:56 am
Evil Kraig F (4/6/2012)
"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
April 6, 2012 at 3:44 am
TravisDBA (4/5/2012)
Any time you want to see the warts & all presentation, come watch mine. I don't hold back. We have a ton of advantages over Visual Studio. They 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
April 5, 2012 at 12:29 pm
If your server is so busy that a well-structured server-side trace will bring it down, you have some serious issues. While extended events (introduced in SQL Server 2008) are much...
"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
April 5, 2012 at 11:07 am
They are just calculations. Nothing more. They're based on statistics, so the more accurate your statistics are, the more accurate those numbers are likely to be. However, because some things...
"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
April 5, 2012 at 10:45 am
Lynn Pettis (4/5/2012)
Grant Fritchey (4/5/2012)
Lynn Pettis (4/5/2012)
I'm sorry, but I started laughing to myself when I read this one.
Look at it as a complement. To many people, we're the SQL...
"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
April 5, 2012 at 9:24 am
John Dempsey (4/5/2012)
Grant Fritchey (4/5/2012)
Any time you want to see the warts & all presentation, come watch mine. I don't hold back. We have a ton of advantages over Visual...
"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
April 5, 2012 at 9:24 am
Steve Jones - SSC Editor (4/5/2012)
Eric M Russell (4/5/2012)
"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
April 5, 2012 at 9:22 am
Lynn Pettis (4/5/2012)
I'm sorry, but I started laughing to myself when I read this one.
Look at it as a complement. To many people, we're the SQL Server documentation. That's pretty...
"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
April 5, 2012 at 9:12 am
TravisDBA (4/5/2012)
"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
April 5, 2012 at 9:10 am
Viewing 15 posts - 11,131 through 11,145 (of 22,219 total)