Viewing 15 posts - 14,821 through 14,835 (of 22,227 total)
And in addition to all that, I'd like to recommend a good book... look 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
June 18, 2010 at 7:19 am
Gail may have already spotted the problem. If you're just running the SELECT and there's no filter on the data, it's doing a scan of all data across all the...
"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
June 18, 2010 at 7:19 am
That is honestly a huge topic. It's not one that you're going to get good guidance on from responses on a blog. As a starting point you could look at...
"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
June 18, 2010 at 7:08 am
It's possible that if you're running REINDEX or other defrag routines that the new indexes could be affecting the log size. Other than that, no, I can't think of 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
June 18, 2010 at 7:03 am
GilaMonster (6/18/2010)
Lynn Pettis (6/17/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
June 18, 2010 at 5:54 am
PradeepVallabh (6/16/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
June 16, 2010 at 9:14 am
PradeepVallabh (6/16/2010)
Thanks for the info.....So in short the queries with estimated execution plans in the cache run faster
Well, that really depends on a lot of factors. I'll say this, 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
June 16, 2010 at 9:07 am
Gianluca Sartori (6/16/2010)
Grant Fritchey (6/16/2010)
I swear, about a third of our IT staff could fall into a bottomless pit and we wouldn't notice for a week.
Do we work for the...
"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
June 16, 2010 at 6:36 am
You're probably looking at the plan cache. All plans in the plan cache are estimated plans. Every query you execute gets an actual execution plan, they have to. Not 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
June 16, 2010 at 6:30 am
Yep, I agree with Gianluca, probably statistics.
It's also possible that you're seeing parameter sniffing. You'd want to look at the execution plan of the query to see what it's doing....
"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
June 16, 2010 at 6:29 am
If you need to maintain artificial keys between multiple databases I'd suggest one of two approaches, each of which has strengths & weaknesses. First, set up an ID service that...
"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
June 16, 2010 at 6:27 am
I would look at getting a license for SQL Server 2008 R2. You can then use multi-server management to put this to work. Otherwise, you need to cobble something together...
"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
June 16, 2010 at 6:24 am
Yes, you can run reports while policies are being evaluated but you won't see a complete picture. Out of the box, no, you can not run policies against anything except...
"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
June 16, 2010 at 6:16 am
GilaMonster (6/16/2010)
Steve-3_5_7_9 (6/16/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
June 16, 2010 at 6:12 am
Steve Jones - Editor (6/15/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
June 15, 2010 at 5:40 pm
Viewing 15 posts - 14,821 through 14,835 (of 22,227 total)