Viewing 15 posts - 11,401 through 11,415 (of 22,224 total)
You're looking at a 500+ rows in a multi-statement UDF and you've got index hints inside the queries? I think you're digging a very deep hole. Hints should be used...
"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
January 18, 2012 at 4:15 am
Jeff Moden (1/17/2012)
Grant Fritchey (1/17/2012)
The thing is, some questions lend themselves to that style 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
January 17, 2012 at 9:09 pm
Good to see you got the answer. Thanks Gianluca
"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
January 17, 2012 at 7:49 am
Simply joining the tables, yes, you're going to return two rows. So, what are the filter criteria that makes it so you'll only get one? Add that to a WHERE...
"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
January 17, 2012 at 6:18 am
I strongly recommend you DO NOT join the two views together. Joining one view to another or nesting views within each other leads to incredibly complex execution plans which 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
January 17, 2012 at 5:49 am
L' Eomot Inversé (1/17/2012)
Jeff Moden (1/16/2012)
I'll reserve my opinion on this but thought I'd give everyone a heads up...http://wikimediafoundation.org/wiki/English_Wikipedia_anti-SOPA_blackout
I believe (sadly) that this will have no effect at all...
"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
January 17, 2012 at 5:45 am
We do have ASK.SQLServerCentral.Com if you really prefer posting to a place with a reputation system.
The thing is, some questions lend themselves to that style of web site. But many...
"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
January 17, 2012 at 5:32 am
You can make it a little cleaner:
DECLARE @MyParam1 VARCHAR(50) = '42',
@MyParam2 INT = 42,
@MyParam3 TINYINT = 2 ;
"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
January 17, 2012 at 5:25 am
A quick summary of the things you can do for database backup testing. The best thing you can do is to test the restore. There are some third party solutions...
"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
January 17, 2012 at 5:12 am
The cached plan only saves you recompile time for performance. A multi-statement table valued function is only good for working with very small data sets. This is because, as Gail...
"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
January 17, 2012 at 5:08 am
GilaMonster (1/13/2012)
azdzn (1/13/2012)
it still looks like 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
January 17, 2012 at 5:06 am
Gianluca Sartori (1/13/2012)
GilaMonster (1/13/2012)
"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
January 17, 2012 at 5:05 am
Just so you know, you're venturing into a huge topic area. In my signature line are two books that might help. The one on execution plans is available in electronic...
"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
January 17, 2012 at 5:02 am
Queries don't stay available in the cache forever. If you ran it once and it had a low cost, chances are if there's any memory pressure on the system at...
"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
January 17, 2012 at 4:59 am
Jeff Moden (1/16/2012)
I'll reserve my opinion on this but thought I'd give everyone a heads up...http://wikimediafoundation.org/wiki/English_Wikipedia_anti-SOPA_blackout
The House of Representatives have permanently shelved this abomination. We just need to light...
"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
January 17, 2012 at 4:41 am
Viewing 15 posts - 11,401 through 11,415 (of 22,224 total)