Viewing 15 posts - 6,076 through 6,090 (of 22,219 total)
butcherking13 (5/19/2015)
I'm curious about two...
"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
May 19, 2015 at 8:15 am
I've got a short article[/url] on all the steps to really ensure that your backups are good.
"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
May 19, 2015 at 4:57 am
You'll have to test it, monitor it, and adjust as needed. That's the normal approach to any of this. I'm not even sure that I would mess with the fill...
"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
May 19, 2015 at 4:55 am
I'm not sure that any data types were added. You can see all the new features and functions in the Microsoft documentation.
"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
May 19, 2015 at 4:53 am
ramana3327 (5/18/2015)
In that case we need to take everyday full backup right?Currently we have weekly full backup & 15 min log backups.
Jeff didn't say to throw away differentials, just to...
"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
May 19, 2015 at 4:35 am
audiocool (5/19/2015)
I knew that no matter if I pump in more RAM to the new SQL Server, it will just slowly consume it compare to current situation.
For my case,...
"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
May 19, 2015 at 4:32 am
Lynn Pettis (5/18/2015)
Michael L John (5/18/2015)
Jeff Moden (5/18/2015)
andrew gothard (5/18/2015)
Jeff Moden (5/14/2015)
Me, the interviewer: As the Lead Developer on this project, we're very interested in...
"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
May 18, 2015 at 10:21 am
audiocool (5/18/2015)
I'm not sure whether...
"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
May 18, 2015 at 10:18 am
audiocool (5/18/2015)
Many thanks for your valuable advise. Could you please guide me through the steps to troubleshoot the problems in my environment. I had around 10 databases with 2...
"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
May 18, 2015 at 6:53 am
From what you're describing here, just a backup and restore will work. But if you're only looking to move the structures and the DDL for the database, you might consider...
"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
May 18, 2015 at 6:49 am
If you look at the plans, the very first operator, the SELECT operator, has a little exclamation mark. That's a warning. If you open the properties for this, you'll get...
"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
May 18, 2015 at 4:46 am
Jeff Moden (5/16/2015)
Me: Tell...
"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
May 17, 2015 at 4:00 am
David Webb-CDS (5/15/2015)
"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
May 16, 2015 at 3:33 am
Better to understand why you're getting different plans. Usually this is because of differences in statistics between the machines. But, it could be other stuff. For example, differences in the...
"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
May 16, 2015 at 3:25 am
Sean Lange (5/15/2015)
Luis Cazares (5/15/2015)
Leading...
"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
May 15, 2015 at 10:45 am
Viewing 15 posts - 6,076 through 6,090 (of 22,219 total)