Viewing 15 posts - 7,831 through 7,845 (of 22,224 total)
Kwisatz78 (7/2/2014)
I actually have your book SQl Server 2012 Performance Tuning. The flow of the book seems to be arming the reader with techniques for tuning queries followed...
"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 2, 2014 at 6:24 am
All performance tuning should start at the server. Ensure the server is well-configured first. Then start gathering metrics, again, at the server level to start. Wait stats, etc. Be sure...
"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 2, 2014 at 5:07 am
Back to your basic argument, I'm with you. Using the language in the standard mechanism by default is usually the better approach. There are any number of valid reasons 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 2, 2014 at 3:41 am
GilaMonster (7/2/2014)
wilks (7/2/2014)
I had misunderstood the scan count from IO statistics, I see now it can refer to an index or table scan.
No, it doesn't. It is not a count...
"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 2, 2014 at 3:39 am
You could capture a lot more information using extended events. You can usually capture machine name and other information with it. I'm not sure which event I'd set this 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 2, 2014 at 3:33 am
Just piling on a bit so you have some reinforcement. I'm with Sean and Jeff. Create the tables, but put them in a different schema. Separating function by naming convention...
"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 2, 2014 at 3:28 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
July 2, 2014 at 3:24 am
Sounds like you have it covered. Lock escalation occurs, but I don't find it's a common thing. If you're doing the type of data load that's going to benefit from...
"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 2, 2014 at 3:23 am
Sarah Wagner (7/1/2014)
SQLRNNR (7/1/2014)
Nice first article Sarah (at least here on SSC). If you have others, please let us know where to find them.
This was my first article. ...
"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 1, 2014 at 4:49 pm
I've been hearing a lot of mixed stuff lately on the need to update statistics. Personally, I'd do it. It's not going to hurt anything and might help.
You can switch...
"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 1, 2014 at 12:06 pm
michael.minarzick 97083 (7/1/2014)
There's no doubt that...
"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 1, 2014 at 11:59 am
sqldriver (7/1/2014)
Tough crowd. I thought the NOLOCK on an update was amusing.
But of course it 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
July 1, 2014 at 8:10 am
I kind of glossed over the title, but thanks Brent for pointing it out...
I am NOT smarter than... oh, just about anyone. I've just been around long enough to have...
"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 1, 2014 at 7:18 am
Backups. Tested backups (which means a restore to a test machine somewhere). Nothing is more important than ensuring the continuity of your organization. That means talking to the business 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 1, 2014 at 7:12 am
thomashohner (7/1/2014)
jcrawf02 (7/1/2014)
Grant Fritchey (6/30/2014)
"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 1, 2014 at 7:03 am
Viewing 15 posts - 7,831 through 7,845 (of 22,224 total)