Viewing 15 posts - 14,686 through 14,700 (of 22,227 total)
shayy (7/12/2010)
column, then an index on that column can help.
Thanks a lot for...
"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 7:15 am
Another consideration, adding PK's means you're adding an index, clustered or nonclustered, to a table where none previously existed. That will affect performance, probably positively, but possibly negatively.
You have tons...
"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 7:11 am
Mike01 (7/12/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 7:08 am
That's a final approach to logical deletes. I'd just keep an eye on performance because, presumably, you're filtering on that bit, which won't index well, so you could see some...
"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 7:07 am
You're way off in your use of @@RowCount. Every time something is referenced or updated, you're going to get a change in @@RowCount. If you want to use it, it...
"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 7:04 am
shayy (7/12/2010)
1. As i mentioned, i only have one query (maybe 2) which takes the data ordered by ProjectName
2. about using the WHERE, 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
July 12, 2010 at 6:56 am
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
Viewing 15 posts - 14,686 through 14,700 (of 22,227 total)