Viewing 15 posts - 13,171 through 13,185 (of 22,232 total)
How big is the varchar field? While they are not as performant as integers, if it's not large and the data inside is selective enough, you can put an index...
"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
February 22, 2011 at 3:15 pm
I know you don't want to reengineer, although I'd consider it, but have you looked at going with Read Committed Snapshot for your isolation level? That will allow you much...
"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
February 22, 2011 at 8:10 am
phancey (2/22/2011)
"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
February 22, 2011 at 6:06 am
Fox87 (2/22/2011)
The SQL Upgrade Advisor doesn't work if I run it on my SQL 2008 instance.
It give the following error:
SQL Server version: 10.00.4000 is not supported by this...
"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
February 22, 2011 at 6:01 am
srikant maurya (2/21/2011)
You can rewrite the query but execution plan are same for both t-sql (index scan)select * from contact where patindex('%a',first_name)>0
That approach will lead to scans instead 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
February 22, 2011 at 5:45 am
Is any single index bigger than 7gb? I don't think you'll need to worry about uncommitted transactions exceeding that value. But, if you have to, break down the process, do...
"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
February 22, 2011 at 5:34 am
Ah, the leading edge of your clustered index, at least in the sample, is always zero. That's going to make for some pretty horrific statistics, probably leading to scans 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
February 21, 2011 at 8:04 pm
A similar query plan is not the same thing as the same query plan.
Regardless, I suspect you're hitting one of the exceptions, it's just not clear which one. You're seeing...
"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
February 21, 2011 at 12:28 pm
Forced Parameterization has a huge number of possible exceptions. If this code is using prepared statements, then that is one of the exceptions. Here's the list.
"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
February 21, 2011 at 11:07 am
I'm sure I'm missing something, but what specifically is the problem? What's going wrong?
"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
February 21, 2011 at 11:03 am
You're cross over a few items there. The recovery model of the database and index rebuilds shouldn't be cross-concerns. Space on the drive is because you'll need room 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
February 21, 2011 at 11:00 am
It really depends on your job and your environment. Like Gus already said, index management and backups are the most common ones, but different situations are going to require you...
"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
February 21, 2011 at 10:52 am
It really depends on how you work with the developors. Personally, I try to work on the database the same way they work on code, putting it into source control,...
"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
February 21, 2011 at 10:47 am
GSquared (2/21/2011)
Grant Fritchey (2/21/2011)
And this post makes 10,000 points. On to getting 10,000 posts.Figured I'd break the threshold on The Thread.
Grats!
(For some reason, I keep thinking you were ahead 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
February 21, 2011 at 9:24 am
Whatever acts as the aggregate to get you the top 90% is also the thing that you can order by to get the first 50 using TOP 50 with 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
February 21, 2011 at 7:50 am
Viewing 15 posts - 13,171 through 13,185 (of 22,232 total)