Viewing 15 posts - 7,576 through 7,590 (of 22,232 total)
MJ-1115929 (8/20/2014)
Thanks for shedding some light and highly appreciate the help provided, and nice to meet you , I have read your book on performance tuning 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
August 20, 2014 at 3:36 pm
I'm with Jack, I'd suggest getting in direct touch with Microsoft. A crash of the instance is not something simply changing a setting or tuning a query is going 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
August 20, 2014 at 9:17 am
er.mayankshukla (8/20/2014)
The page compression on Table reduces the size of table as well as size of Clustered Index without any change in size to NonClustered Index.
Now My...
"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, 2014 at 6:24 am
MJ-1115929 (8/20/2014)
We have a new project that requires some modeling ,design changes and performance tuning , as of now I am Administration side which I have only basic idea...
"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, 2014 at 4:31 am
It really depends on what you're looking for. For example, Red Gate SQL Backup goes above and beyond the CMS when dealing with backups across multiple servers, especially in how...
"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, 2014 at 4:21 am
Welsh Corgi (8/19/2014)
Thanks for the recommendations.When I attempt to install Ignite I get an error that the Wizard was interrupted before Ignite could be installed.
I've installed it three times without...
"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 3:42 pm
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
Viewing 15 posts - 7,576 through 7,590 (of 22,232 total)