Viewing 15 posts - 12,646 through 12,660 (of 22,224 total)
You can always take them down the company store and exchange them for valuable merchandise.
Where was the company store located again?
"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 27, 2011 at 7:54 am
Removing indexes is generally not going to help SELECT performance. You need to understand what your queries are doing in order to correctly configure your indexes, not simply dump them....
"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 27, 2011 at 7:52 am
kanuri.sandeep (4/27/2011)
and don't forget to denormalize where you need to.
Without a lot more information, I wouldn't suggest any denormalization until you have a very thorough understanding of where the 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
April 27, 2011 at 7:47 am
After you read through Gail's excellent articles, if you still need more info, please check out my book "SQL Server 2008 Query Performance Tuning Distilled."
"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 27, 2011 at 7:45 am
You can create a composite project that combines the server project and that database project.
"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 27, 2011 at 7:44 am
Just saying you have a 300gb database with many users is not nearly enough to begin to make suggestions for what to do with that database. It's not even remotely...
"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 27, 2011 at 7:24 am
Brandie Tarvin (4/27/2011)
SQLRNNR (4/26/2011)
When did Brandie crack the top 25?Wait. What?
I'm in the top 25?
WHOO HOO! Steve, I'm glad my bribe worked! @=)
Well done. That's a serious milestone, especially considering...
"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 27, 2011 at 5:47 am
For that one query, yeah, it sounds like it needs more up to date statistics.
"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 26, 2011 at 3:49 pm
Take a look at "SQL Server Team-based Dvelopment." [/url]It's not going to tell you how to move large amounts of data. That's a different issue entirely.
"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 26, 2011 at 3:46 pm
ChrisM@home (4/26/2011)
Is it me, or are the posted questions from developers working on medical systems a little worrying?
I used to work for a medical software company. it was a nightmare...
"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 26, 2011 at 3:16 pm
Ninja's_RGR'us (4/26/2011)
So plan B would be? Collect a trace and sum up to reads / writes columns?
I think I'd call it step 2 of Plan A, but yeah.
"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 26, 2011 at 6:51 am
Ninja's_RGR'us (4/26/2011)
Grant Fritchey (4/26/2011)
Ninja's_RGR'us (4/26/2011)
Grant Fritchey (4/26/2011)
You need a fundamental assessment of the system...
"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 26, 2011 at 6:26 am
Ninja's_RGR'us (4/26/2011)
Grant Fritchey (4/26/2011)
You need a fundamental assessment of the system done. It sounds...
"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 26, 2011 at 6:17 am
I would look first at the SQL Server error log. You can see that in the Management folder in SSMS. I would also look at the Event Viewer on 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
April 26, 2011 at 6:03 am
Referential integrity is also a speed issue. It speeds things up. Here's a blog post outlining why[/url].
You need a fundamental assessment of the system done. It sounds like you don'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
April 26, 2011 at 6:00 am
Viewing 15 posts - 12,646 through 12,660 (of 22,224 total)