Viewing 15 posts - 12,646 through 12,660 (of 22,227 total)
There have been tests, and you can search for them online, that show that a well defined clustered index speeds up inserts over and above having a heap table. 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
April 27, 2011 at 8:20 am
GilaMonster (4/27/2011)
Grant Fritchey (4/27/2011)
Where was the company store located again?Cambridge? Or Denver?
With all your points I figured you'd just buy the store and move it down to SA to force...
"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 8:18 am
You need to look in the project properties for the database. It's set to recreate the entire database. You can have it do incremental builds. This article[/url] is a bit...
"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 8:03 am
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
Viewing 15 posts - 12,646 through 12,660 (of 22,227 total)