Viewing 15 posts - 10,531 through 10,545 (of 22,219 total)
GilaMonster (8/22/2012)
Grrr. Why do some people want to nitpick holes in things I say and do it in a way that sounds very much like a personal attack?
Same reason you...
"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
August 22, 2012 at 3:04 am
Yes, that does make sense. I'd want to see a good heavy load, especially if I was relying on the old single-threaded model of trace replay.
You'd think this would be...
"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
August 21, 2012 at 6:50 pm
You can use the old Profiler to playback a trace. That will act as a measurable set of tests and will put some load on the system. You just can'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
August 21, 2012 at 5:04 am
It is amazingly faster. It's just not the same at all.
"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
August 20, 2012 at 12:47 pm
Actually, yeah, looks like 2005 might be out. That stinks. Never noticed that before.
"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
August 20, 2012 at 12:31 pm
Since it's backing up with NOINIT, it's likely putting one backup on top of another. You may not be seeing the right 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
August 20, 2012 at 12:31 pm
Yes, you can point the distributed playback mechanism to 2005. It just needs a database to connect to. But, the install is 2012, so you have to have that first.
"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
August 20, 2012 at 11:20 am
The size of the index really depends on the size of the CHAR field and the size of the number field you're comparing. If the CHAR is CHAR(2) and you're...
"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
August 20, 2012 at 11:18 am
The error you're getting, "This differential backup cannot be restored because the database has not been restored to the correct earlier state.", is usually indicative that the full backup and...
"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
August 20, 2012 at 11:14 am
I'm not worried one way or another about an index on a CHAR column. However, storing numbers in string columns is very concerning. You're going to hit issues when you...
"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
August 20, 2012 at 10:39 am
Maybe I misunderstood, you're trying to apply the same differential that is matched to the first backup to a second, different backup? You can't do that. Differentials are tied directly...
"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
August 20, 2012 at 10:36 am
Just a side note. Be careful about how you think about log backups. They're not done to maintain the log size or shrink logs or anything like they. Log backups...
"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
August 20, 2012 at 10:33 am
Will you absolutely have IO issues? No one can say based on the information provided. Are you more likely to have IO issues having data & log on the same...
"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
August 20, 2012 at 5:21 am
Take a look at the first operator in the execution plan and look at it's properties. Is the reason for early termination "Good enough plan found"? Then the optimizer did...
"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
August 17, 2012 at 12:07 pm
Any time you have licensing and pricing questions, you're best source is Microsoft. But, in all the conversations I've had with them about this, my understanding is, if you 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
August 17, 2012 at 11:59 am
Viewing 15 posts - 10,531 through 10,545 (of 22,219 total)