Viewing 15 posts - 14,701 through 14,715 (of 22,227 total)
The Dixie Flatline (7/9/2010)
One...
"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
July 9, 2010 at 9:07 am
Kit G (7/9/2010)
But now I have a plan.
Cool. Should there be an evil laugh after "But now I have a plan"? :w00t: This is after all, The Thread....
"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
July 9, 2010 at 8:22 am
I'd be interested in seeing it too (unless you already sent it to me & I lost it, entirely possible). We've been getting great results with our indexes, but we...
"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
July 9, 2010 at 8:21 am
lverea-783150 (7/9/2010)
I 'm starting to manage a very big non-documented database created by another people.
I wish to know if there is a way (an script or something like that) 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
July 9, 2010 at 7:36 am
mupparaju78 (7/9/2010)
which one is the best performence "index or cluster index"
Yes!
More detailed, it depends.
Even more detailed, assuming a covering index, meaning an index that can satisfy all the requirements 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
July 9, 2010 at 7:08 am
Sorry, nothing built in for that. You'll have to roll your own.
"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
July 9, 2010 at 6:50 am
I'd take a look at the sys.dm_tran_locks dynamic management view. You could also use sys.dm_exec_requests to see which sessions are blocked, but just to see all locks, the first DMV...
"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
July 9, 2010 at 6:49 am
The industry had respect for the traditional DBA?
There are a lot of products and processes out these days, specifically targeted at eliminating the need for DBA's. For some reason we've...
"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
July 9, 2010 at 6:43 am
aravind-305595 (7/9/2010)
update...
"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
July 9, 2010 at 6:00 am
oliver.morris (7/9/2010)
Thank you for your continued support. I already have Alastair's superb book.
I have attached the 3 execution plans to for the 3 queries in your post. They all use...
"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
July 9, 2010 at 5:56 am
GilaMonster (7/8/2010)
Did I miss a major announcement or something?
Not that I'm aware of, but then I miss the hardware/server stuff sometimes.
"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
July 8, 2010 at 12:31 pm
Tom Robertson (7/8/2010)
the reason I think that is because
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
July 8, 2010 at 12:10 pm
Sharepoint most definitely has to run as 'sa.' I've never seen anything to suggest otherwise and everything I've seen it do on the server pretty much suggests that's how 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
July 8, 2010 at 11:46 am
I wish I could say yes so you'd buy a copy, but no, it doesn't cover spatial queries. If you don't have a copy of Alastair Aitchison's excellent book, I'd...
"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
July 8, 2010 at 11:08 am
Tom Robertson (7/8/2010)
I neglected one important piece of info. The development workstations are running sql 2008, database is in 2005 mode
production servers(I've tested 3 different ones...
"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
July 8, 2010 at 10:43 am
Viewing 15 posts - 14,701 through 14,715 (of 22,227 total)