Viewing 15 posts - 7,831 through 7,845 (of 22,219 total)
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
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 6:51 am
By the way, change that cost threshold value. The default value of 5 is way too low for most systems. I'd suggest bumping it to 50 for an OLTP system...
"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 6:50 am
Cost threshold for parallelism on both boxes. ANSI connection settings on both boxes. Get an estimated execution plan from both boxes and compare them.
"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 5:13 am
Check the execution plan for both. See what's being generated by the optimizer. That will help you understand if there is something mundane like statistics at fault, or if you're...
"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 5:11 am
That's actually a tough problem. If this were a SQL Server 2012 instance I would ask if it was possible that those clients be Read Only. In this case you...
"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 5:09 am
Viewing 15 posts - 7,831 through 7,845 (of 22,219 total)