Viewing 15 posts - 15,451 through 15,465 (of 22,227 total)
It's logical, but a poor choice. In order to implement it, all access to your system would need to be through dynamic tsql, where you build the sql statement. This...
"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 21, 2010 at 6:08 am
Third vote. You're on the money the other guys need to go back & hit the books.
"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 21, 2010 at 6:01 am
You say the data is "huge" but what does that mean in real terms? It sounds like you may have tuning opportunities in the SSIS data load.
Regardless, one way around...
"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 21, 2010 at 5:59 am
Sumanta-1056020 (4/21/2010)
We got microsoft recommendation like this..
An index that is more than 5 percent or less than 30 percent fragmented should be reorganized. In addition, an index that is...
"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 21, 2010 at 5:54 am
I'd start with the Books Online. You're listing a large swath of different performance metrics, so there's not going to be a single source for this information except for a...
"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 21, 2010 at 5:49 am
Whisper9999 (4/20/2010)
Grant Fritchey (4/20/2010)
"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 21, 2010 at 5:18 am
It will rebuild the indexes, but it might not be the most optimal method, but I only say that because, depending on the table, some tables might be better off...
"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 20, 2010 at 4:39 pm
greggoble2 (4/20/2010)
I just installed Visual Studio 2010 and it has compare functionality built in. It is pretty nice.
It is decent and functional. I don't think it quite has all...
"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 20, 2010 at 11:11 am
CirquedeSQLeil (4/20/2010)
Grant Fritchey (4/20/2010)
...and I'll give you as big a share of the royalties as I getAnd based on previous comments - we know that ain't very much at all.:-D
Shhhhhhh!...
"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 20, 2010 at 9:02 am
CirquedeSQLeil (4/20/2010)
WayneS (4/20/2010)
Roy Ernest (4/20/2010)
... I am always learning here...
And that is why I help out... I end up learning more, and it has the benefit of enforcing what...
"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 20, 2010 at 8:54 am
My statement "dubious origin" was probably badly phrased. I think "dubioius benefit" would be more accurate.
But I would still be curious about the origin of some of the statements.
"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 20, 2010 at 7:39 am
hrushiatre (4/20/2010)
If you have ever performed a SELECT COUNT(*) on a very large table, you know how long it can take.
For example, when 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 20, 2010 at 7:03 am
There are options for the compare, such as "Ignore white space," that you may have unchecked (or checked, depending). I'd go there to see what the settings are.
"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 20, 2010 at 6:41 am
It really depends on how you define "affect performance." The fact of the matter is, you're using server resources for tracking errors, possibly at the time when server resources are...
"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 20, 2010 at 6:40 am
Like Paul says, huge topic. The simple answers are frequently enough wrong, but still a good starting point.
Look for scans, index or table, these are frequently, but not always, an...
"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 20, 2010 at 6:33 am
Viewing 15 posts - 15,451 through 15,465 (of 22,227 total)