Viewing 15 posts - 13,966 through 13,980 (of 22,227 total)
One other thing, SQL Server 2008 does give you some ability to help with dynamic SQL. You can set the server to "Optimize For Ad Hoc Workloads." Here's a description...
"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
November 4, 2010 at 6:03 am
You have to know that with dynamic queries, every single change to the string that defines the query means you get a new execution plan, unless you use parameterized queries...
"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
November 4, 2010 at 5:56 am
In addition to limiting the indexes that you perform maintenance on based on fragmentation, I'd also limit based on the number of pages. Defragging or rebuilding an index less than...
"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
November 4, 2010 at 5:36 am
One of the keys to indexing is to watch the leading edge, the first column. You really need to avoid, as much as humanly possible (I'd say eliminate, but that's...
"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
November 4, 2010 at 5:34 am
Roy Ernest (11/3/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
November 3, 2010 at 7:42 am
GilaMonster (11/3/2010)
Grant Fritchey (11/3/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
November 3, 2010 at 6:14 am
GilaMonster (11/3/2010)
Gianluca Sartori (11/3/2010)
I'm not suggesting anyone to cheat, but the voting system relies on browser cookies to determine if a vote was placed... :Whistling:
and I have 2 computers and...
"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
November 3, 2010 at 5:38 am
GilaMonster (11/3/2010)
BrainDonor (11/3/2010)
I wouldn't say that. There's still a week of voting and the down votes make changes happen quick. Someone can vote up another guy and vote me down...
"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
November 3, 2010 at 5:19 am
BrainDonor (11/3/2010)
I wouldn't say that. There's still a week of voting and the down votes make changes happen quick. Someone can vote up another guy and vote me down and...
"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
November 3, 2010 at 5:18 am
Kit G (11/2/2010)
Roy Ernest (11/2/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
November 2, 2010 at 1:07 pm
CirquedeSQLeil (11/2/2010)
GilaMonster (11/2/2010)
Grant Fritchey (11/2/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
November 2, 2010 at 1:03 pm
GilaMonster (11/2/2010)
Grant Fritchey (11/2/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
November 2, 2010 at 1:01 pm
Jeff Moden (11/2/2010)
Grant Fritchey (11/2/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
November 2, 2010 at 11:07 am
Fixed it on the post.
"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
November 2, 2010 at 9:41 am
Alvin Ramard (11/2/2010)
Grant Fritchey (11/2/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
November 2, 2010 at 8:38 am
Viewing 15 posts - 13,966 through 13,980 (of 22,227 total)