Viewing 15 posts - 5,266 through 5,280 (of 22,219 total)
Andy Warren (1/4/2016)
"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 4, 2016 at 5:52 am
It's so weird that your Toshiba is dead and mine is chugging along (knock wood).
Maybe you're just hard on machines. Ha!
(For those who don't know, I dropped 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 4, 2016 at 5:50 am
The biggest issue for multi-statement table valued functions is that, regardless of recompile, since they don't have statistics and are always based off of 100 rows (in 2014 using 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
January 2, 2016 at 8:44 am
As Jack says, in the scenario described, the optimizer is likely to arrive at the same plan regardless of the approach you take. However, what you're proposing to do with...
"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
December 30, 2015 at 3:19 am

"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
December 29, 2015 at 11:51 am
Phil Parkin (12/29/2015)
Grant Fritchey (12/29/2015)
Eirikur Eiriksson (12/29/2015)
"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
December 29, 2015 at 6:51 am
Eirikur Eiriksson (12/29/2015)
"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
December 29, 2015 at 6:13 am
Jeff Moden (12/28/2015)
Grant Fritchey (12/28/2015)
Jeff Moden (12/28/2015)
Grant Fritchey (12/28/2015)
"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
December 28, 2015 at 9:14 am
Jason A. Long (12/28/2015)
Grant Fritchey (12/28/2015)
"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
December 28, 2015 at 8:38 am
Jason A. Long (12/28/2015)
Grant Fritchey (12/28/2015)
"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
December 28, 2015 at 8:28 am
Jeff Moden (12/28/2015)
Grant Fritchey (12/28/2015)
"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
December 28, 2015 at 8:24 am
I have two presentations I do on best practices. Both slide decks are available on slideshare.net. That could act as a guide. Just give me some attribution if you 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
December 28, 2015 at 7:26 am
Thanks for the feedback. I think understanding, not the data itself, but what I need to do with the data, not the algorithm, but the preparation, is the key. I'm...
"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
December 19, 2015 at 4:55 am
etm1109 (12/18/2015)
"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
December 18, 2015 at 7:31 am
I worked for a couple of dot coms back in the day. They basically used the "death march" approach to software development. Set a deadline w/o understanding the problem, then...
"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
December 18, 2015 at 7:18 am
Viewing 15 posts - 5,266 through 5,280 (of 22,219 total)