Viewing 15 posts - 17,116 through 17,130 (of 22,219 total)
If you're having trouble meeting all the configuration requirements for AdventureWorks (and Gift is right), there is a Lite version that you can use. It's much easier to install. Unfortunately,...
"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 25, 2009 at 7:10 am
Can you post actual execution plans for each of the queries?
Since you're testing it on two different servers, are you 100% positive that the same data exists in each? Also,...
"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 25, 2009 at 7:06 am
At this point, this is a cross-post with this one:
http://www.sqlservercentral.com/Forums/Topic741702-338-1.aspx
Please don't ask the same question in multiple places. I posted a possible answer in the other location.
"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 25, 2009 at 7:03 am
I'd have to see the execution plans of the queries to be sure, but I'll bet you the table and the index have the same key. If you're doing 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
June 25, 2009 at 6:59 am
Eswin (6/25/2009)
How to avoid clustered and non-clustered index Scan's and also table scans.
Do what Gail says. Avoid functions on columns in the WHERE clause and JOINs. Use operations that can...
"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 25, 2009 at 6:56 am
Gianluca Sartori (6/25/2009)
I don't' remember such a rainy and (relatively) cold summer...
"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 25, 2009 at 6:38 am
Paul White (6/24/2009)
"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 25, 2009 at 6:29 am
Alexander Kuznetsov (6/24/2009)
"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 24, 2009 at 1:28 pm
Can I ask what types of scripts you're looking for? Do you mean scripts to monitor blocking?
"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 24, 2009 at 12:46 pm
You need to look at the queues and wait states counters. That will tell you what is slowing down. From there you can determine what's causing 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
June 24, 2009 at 12:44 pm
Alexander Kuznetsov (6/24/2009)
What do I need Active solution configuration and Active solution platform for?
This is a database project, not a C# one, so why am I exposed to and maybe...
"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 24, 2009 at 12:39 pm
In addition to Gert's blog, Barclay Hill is posting on best practices with VSTS:DBE. It's worth a read. http://blogs.msdn.com/bahill/default.aspx
"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 24, 2009 at 6:59 am
Florian Reischl (6/24/2009)
I'm still not the best friend of SQL integration in Visual Studio but I think the new database projects become better and better and it seems...
"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 24, 2009 at 6:57 am
ALZDBA (6/24/2009)
( http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed )
FYI: The Datadude's lair: http://blogs.msdn.com/gertd/default.aspx 😉
I'm not yet a user, but...
"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 24, 2009 at 6:56 am
Paul White (6/24/2009)
Maybe we read the original post differently, but:
DBA (6/9/2009)
Hi, i have many complains of having lock escalations in my DB
Notice the word 'complains' not 'complaints' - 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
June 24, 2009 at 5:40 am
Viewing 15 posts - 17,116 through 17,130 (of 22,219 total)