Viewing 15 posts - 6,271 through 6,285 (of 22,219 total)
Eirikur Eiriksson (4/19/2015)
spaghettidba (4/19/2015)
Did I say...
"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 19, 2015 at 3:43 am
When querying the wait stats, the real key is going to be getting them before and after the backup to understand where and why things are running slow. Also, 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
April 17, 2015 at 9:59 am
I really dislike the native intellisense, so...
I haven't seen major slow downs, but, make sure you have the latest SP and maybe the latest CU installed on top of your...
"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 17, 2015 at 8:57 am
It actually might be easier to just use T-SQL rather than the GUI. It's much more straight forward to RESTORE:
RESTORE DATABASE 'ANewName'
FROM DISK = 'e:\backups\myotherdb.bak'
WITH MOVE 'logicaldataname' to 'd:\data\anewname.mdf',
MOVE 'logicallogname'...
"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 17, 2015 at 8:52 am
Favorite answer, it depends.
Check the execution plan. It might do TOP on its own. In which case, ignore me. But if it's doing aggregate functions there, modifying it could 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
April 17, 2015 at 7:23 am
Instead of MAX, try a TOP 1 with an ORDER BY.
"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 17, 2015 at 7:13 am
There isn't. If the backup is corrupted, it's gone.
go to the last good backup and then use your log backups to restore back to where you need 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
April 17, 2015 at 7:11 am
One setting I'd change immediately is the Cost Threshold for Parallelism. You have it at the default of 5. Change that to a reasonable number. You can look at your...
"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 17, 2015 at 7:07 am
ShuaibV (4/16/2015)
Can we do this in Redgate SQL Compare 8? We have the older version.Thanks
I'm not sure. You do the compare then go to Tools, Generate Report and look...
"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 16, 2015 at 8:47 pm
Redgate SQL Compare[/url] can do that and then export to XML for Excel. It can also export to HTML and a few other formats.
DISCLAIMER: I work for Redgate.
"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 16, 2015 at 3:34 pm
No, there's still no Best Practices Advisor for 2014. There is the 2014 Upgrade Advisor though. That will help you through the upgrade process.
"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 16, 2015 at 3:23 pm
There's no read/write on the secondaries. Not yet anyway. That's basically merge replication.
"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 16, 2015 at 3:21 pm
If the PK is the single most accessed path to the data, yeah, I agree, it should be clustered, testing or not. Although, I prefer testing and advocate for it....
"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 16, 2015 at 3:16 pm
If you do a search online there are lots of lists of recommended reading. I agree with the post above. I also regularly suggest Craig Mullins book, Database Administration, which...
"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 16, 2015 at 3:10 pm
homebrew01 (4/16/2015)
I'll read up on it for the 2008 servers,...
"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 16, 2015 at 11:49 am
Viewing 15 posts - 6,271 through 6,285 (of 22,219 total)