Viewing 15 posts - 13,156 through 13,170 (of 22,227 total)
In addition to all that excellent informatoin, don't forget that you may also have deal with resource contention, assuming this is a production system.
"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 23, 2011 at 12:09 pm
If you are seeing a consistent disparity between SSMS and the app, check the connections settings to validate that the ANSI settings are the same between both. These can affect...
"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 23, 2011 at 12:06 pm
glennhill (2/23/2011)
Thanks for the reply. I was using term "deadlock" loosely. There was no internal deadlock detected by SQL Server but we did indeed have a blocking chain and...
"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 23, 2011 at 9:21 am
When you say deadlock situation, do you mean that you hit a deadlock error with one process chosen as a deadlock victim?
Or do you mean that you had a 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
February 23, 2011 at 8:27 am
When you say reindex, is that an index defrag or an index rebuild? You'll get less de-fragmentation from the defrag than you do from the rebuild. But also, as was...
"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 23, 2011 at 8:14 am
You might want to take a look at this blog entry[/url]. It addresses exactly what you're talking about.
"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 23, 2011 at 6:17 am
The first thing that comes to mind is merge replication. Have you looked into that? It's hard to set up and administer, but I think it does what you need.
Other...
"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 23, 2011 at 6:15 am
sql_butterfly (2/22/2011)
Hello Friends, Can anyone help me with the strategy to make indexes on OLTP tables ?
That is a gigantic topic and really completely depends on the tables in questions...
"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 23, 2011 at 6:12 am
praveensatya (2/22/2011)
As we know read commited is on by default and which means It prevents transactions to read data if some other transaction is doing some update operation on...
"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 23, 2011 at 6:09 am
Well, it might not be crazy. The optimizer can, note the key word, eliminate tables that are not in use in an execution plan so that if you're only referring...
"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:17 pm
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
Viewing 15 posts - 13,156 through 13,170 (of 22,227 total)