Viewing 15 posts - 11,131 through 11,145 (of 22,224 total)
Go to the source, Microsoft: Each release of SQL Server has a "What's New" page in the books online. Go to this location in the Books Online and 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
April 7, 2012 at 5:24 am
winston Smith (4/7/2012)
Perry Whittle (4/7/2012)
Server side traces have much less impact apart the potential for required disk space depending on what you are monitoring
I know, I use server side traces...
"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 7, 2012 at 5:05 am
Jack Corbett (4/6/2012)
What do you all run to backup your home systems?
I may need to buy a new laptop soon. I use...
"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 9:14 am
If other backups are working on the same devices there may not be anything to check.
At this point, I'd call Microsoft support. I mean, I'm not there and 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
April 6, 2012 at 6:33 am
RESTORE VERIFYONLY will fail with a Litespeed backup. That's expected.
Hmmm... When you run the native backup using checksum, you're not getting an error? But if you run restore it fails....
"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 5:38 am
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
Viewing 15 posts - 11,131 through 11,145 (of 22,224 total)