Viewing 15 posts - 11,791 through 11,805 (of 22,219 total)
That's a big list, I don't think you're going to find a single source for all of it. My book on query tuning has a performance checklist that might help,...
"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
September 28, 2011 at 10:46 am
Kwisatz78 (9/28/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
September 28, 2011 at 9:57 am
Ninja's_RGR'us (9/28/2011)
Grant Fritchey (9/28/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
September 28, 2011 at 8:24 am
WayneS (9/28/2011)
Grant Fritchey (9/28/2011)
Jack Corbett (9/28/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
September 28, 2011 at 8:23 am
Further, if I set a GO in place to separate the commands, it works right every time. Trying it on Denali now.
Same behavior in Denali.
Guess based on behavior, 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
September 28, 2011 at 7:39 am
Not sure, it seems to lag by an execution. If I run it once, it shows as the way I ran it previously.
Version: Microsoft SQL Server 2008 R2 (RTM)...
"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
September 28, 2011 at 7:32 am
Jack Corbett (9/28/2011)
Hey can an execution plan expert (Grant?) take a look at this thread, http://www.sqlservercentral.com/Forums/Topic1181619-338-1.aspx. Interesting behavior noted in execution plan properties with SET ANSI NULLS.
I am NOT...
"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
September 28, 2011 at 7:24 am
Just check the execution plans on the queries to see what, if anything, changes when the index goes away. It's not a measure of performance, but it's always good to...
"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
September 28, 2011 at 7:05 am
Without the structure, this is just a guess, but couldn't you do a subselect to get the unique set of two columns and then join that to the rest 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
September 28, 2011 at 6:16 am
I have used a unique value in a compound index before, but not one that was already indexed, let alone the PK on the table and, I assume, the clustered...
"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
September 28, 2011 at 6:11 am
I'd look at two different ways of doing this, and neither is moving the whole thing and then deleting.
1) You can use transactional replicatoin with filters so that only...
"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
September 28, 2011 at 6:09 am
I've never heard of either of those backup softwares. Just curious, what is it that you're trying to get that you don't get using the native backup capabilities?
"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
September 28, 2011 at 4:42 am
I remember one time we had a requirement that we had to return 100,000 rows in 3 seconds. I'm sitting there with my jaw on my chest asking why 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
September 27, 2011 at 12:21 pm
Tim Walker. (9/27/2011)
We're now about to kick off another round of evaluation (partly...
"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
September 27, 2011 at 8:54 am
Not jargon, but unavoidable technical terms.
You can identify blocking processes by looking at dynamic management objects (DMO). The one that most concerns you is sys.dm_exec_requests. That shows active queries in...
"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
September 27, 2011 at 5:31 am
Viewing 15 posts - 11,791 through 11,805 (of 22,219 total)