Viewing 15 posts - 7,576 through 7,590 (of 22,226 total)
This is such a subjective question. And there are tons and tons of recommendations out there if you search for them. My favorites:
[/url]
and SQL Sentry
For specialized performance...
"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 19, 2014 at 12:29 pm
garry.lovesey (8/19/2014)
Do I need the MERGE...
"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 19, 2014 at 11:35 am
I'm not sure why they have COLLATE statements in the WHERE clause, but it's unlikely to help the code.
Keep an eye on all those variables and parameters too for bad...
"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 19, 2014 at 8:45 am
Not without error messages or something that indicates what's going wrong on your end, no.
"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 19, 2014 at 6:18 am
dstoltz 35443 (8/18/2014)
"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 18, 2014 at 7:01 am
dstoltz 35443 (8/18/2014)
"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 18, 2014 at 6:31 am
After a couple of searches, the only database system that I can find that has a "sequential backup" is MyBB. Here's a forum for that [/url]if that's what you're looking...
"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 18, 2014 at 6:05 am
You'll need to JOIN between Casting and Actor to get the actors. You'll want to GROUP BY a count of the actors from the Casting table for each movie. Then,...
"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 18, 2014 at 6:01 am
All those are server resource measurements, which are interesting and can suggest if you have a problem. But, to quickly determine if things are running long (whether they're maxing out...
"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 18, 2014 at 5:57 am
If you do some searches there are several scripts for monitoring for blocked processes that's one I'd set up. Timing is different on every environment though. I'd also suggest getting...
"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 16, 2014 at 7:32 pm
Databases exist in two places in Azure, in Azure Virtual Machines and in Microsoft Azure SQL Database (MASD). The VMs act exactly like physical boxes or VMs local to 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
August 16, 2014 at 11:10 am
ScottPletcher (8/15/2014)
What are 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
August 16, 2014 at 4:19 am
None at all. If you're only temporarily moving them to 2005, I'd skip the update stats step there, but in general it can't hurt at all to have a fresh...
"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 16, 2014 at 4:16 am
The issue is, there's no way within code or structure to speed up moving 1/4 of a 25 million row table. You are completely dependent on hardware because that will...
"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 15, 2014 at 10:44 am
You're attempting to query 8.25 million records out of 25 million. It's going to scan the table to do this. Indexes won't help. You can get faster or more disks...
"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 15, 2014 at 9:20 am
Viewing 15 posts - 7,576 through 7,590 (of 22,226 total)