Viewing 15 posts - 5,281 through 5,295 (of 22,224 total)
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
Thanks for all the help guys. I'm thinking that I'm going to back off and rethink my blog post. I can't get my head around what I need to do...
"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 17, 2015 at 7:00 am
Seriously, just go and answer their questions. Trying to memorize a set of answers is not going to get you the job. A junior level person with only a year...
"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 17, 2015 at 3:18 am
mattmparker (12/16/2015)
- Does the density/distribution of salesperson-region relationships have high cardinality (salespeople strongly associated with one or two...
"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 16, 2015 at 10:35 am
mattmparker (12/16/2015)
So, for example, a region and a salesperson are likely to be related, not a unique relationship, in each sale.
I think you're on the right track, and just...
"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 16, 2015 at 10:30 am
BuckWoody (12/16/2015)
Not sure I have enough info to answer this, but I have a cheat-sheet referenced on this page that might help, along with some ideas: https://buckwoody.wordpress.com/2015/12/02/knowing-which-statistical-formula-to-use/
Thanks Buck. That's already...
"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 16, 2015 at 10:23 am
It could be Azure, but you really should still see a wait of some kind. I'm with Kevin.
"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 16, 2015 at 9:07 am
Just be aware that SQL Server will use up every bit of memory you give it and that's not a bad thing. The real concern is if you're seeing wait...
"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 16, 2015 at 8:56 am
Steve Jones - SSC Editor (12/16/2015)
Jeff Moden (12/16/2015)
Family always comes first but that's a bugger. Was looking forward to seeing you again, ol' friend.
Ditto. Was hoping to get there,...
"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 16, 2015 at 8:26 am
shirish_padekar (12/16/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 16, 2015 at 4:12 am
The trick is going to be identifying what is causing the so much CPU to be used. Since you're just getting started and you're on 2008, the best approach is...
"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 16, 2015 at 4:07 am
Viewing 15 posts - 5,281 through 5,295 (of 22,224 total)