Viewing 15 posts - 14,686 through 14,700 (of 22,221 total)
If you're building a custom string every time you execute, that's why you're seeing thousands of execution plans. You simply can't do that. Very, very small changes to the text...
"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
July 12, 2010 at 6:47 am
KeyurGohel (7/12/2010)
table: EmpMst
id empcod empname Sdate ...
"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
July 12, 2010 at 6:43 am
chetanr.jain (7/12/2010)
My Client has one service desk application at its two location ( A & B) with individual identical database. Now client wants to merge the both the database (...
"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
July 12, 2010 at 6:39 am
shayy (7/12/2010)
I have a table with these fields:
ID (PK), ProjectName, and some other non important fields (about 20)
Most of my queries i'm doing SELECT * from this table.
there is one...
"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
July 12, 2010 at 6:32 am
If you're working with linked servers and running queries against them, you need to know that unless you specifically use a construct like OPENQUERY and pass in parameter values, 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
July 12, 2010 at 6:27 am
Alvin Ramard (7/11/2010)
Jack Corbett (7/11/2010)
CirquedeSQLeil (7/11/2010)
Alvin Ramard (7/11/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
July 12, 2010 at 5:15 am
Jeff Moden (7/9/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
July 11, 2010 at 6:45 am
Wouldn't be the first time I did something wrong. Time for experimentation.
"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
July 9, 2010 at 1:39 pm
Yeah, it's a bit of a bear.
Fact is, you're right Steve, SharePoint doesn't need 'sa', but it needs about 85% of what 'sa' does, so it's easier to just give...
"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
July 9, 2010 at 11:48 am
The Dixie Flatline (7/9/2010)
One...
"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
July 9, 2010 at 9:07 am
Kit G (7/9/2010)
But now I have a plan.
Cool. Should there be an evil laugh after "But now I have a plan"? :w00t: This is after all, The Thread....
"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
July 9, 2010 at 8:22 am
I'd be interested in seeing it too (unless you already sent it to me & I lost it, entirely possible). We've been getting great results with our indexes, but we...
"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
July 9, 2010 at 8:21 am
lverea-783150 (7/9/2010)
I 'm starting to manage a very big non-documented database created by another people.
I wish to know if there is a way (an script or something like that) 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
July 9, 2010 at 7:36 am
mupparaju78 (7/9/2010)
which one is the best performence "index or cluster index"
Yes!
More detailed, it depends.
Even more detailed, assuming a covering index, meaning an index that can satisfy all the requirements of...
"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
July 9, 2010 at 7:08 am
Sorry, nothing built in for that. You'll have to roll your own.
"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
July 9, 2010 at 6:50 am
Viewing 15 posts - 14,686 through 14,700 (of 22,221 total)