Viewing 15 posts - 5,626 through 5,640 (of 22,219 total)
debby_browne (8/31/2015)
* if you hadn’t caught on, 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
August 31, 2015 at 12:46 pm
GilaMonster (8/31/2015)
What the total size of the Windows and 2 Program Files directories?
I'm trying...
"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
August 31, 2015 at 9:31 am
For the upgrade to 10, I think I'd suggest holding off a while. I'm seeing occasional errors: faulty_hardware_corrupted_page. From the Microsoft forums, quite a few others are as well. Seems...
"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
August 31, 2015 at 7:17 am
briankwartler (8/31/2015)
Which ORMs do you have experience with? I would think that the designers of these ORMs would very much like to hear of your experiences 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
August 31, 2015 at 7:11 am
In addition to changing the Maxdop, make darned sure you change the cost threshold for parallelism. The default of 5 is insanely low.
"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
August 31, 2015 at 6:53 am
I have seen this occur. It's usually in queries that were problematic, but barely adequate, in the older version of SQL Server. The newer optimizer in 2012 just isn't always...
"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
August 31, 2015 at 6:46 am
Without the code and the deadlock graphs all I can do is make some vague suggestions.
Make sure that the queries you're writing access the tables in question in the same...
"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
August 31, 2015 at 6:43 am
My understanding (frequently wrong) is that it's both explicit and implicit transactions whether called by the user or within the server itself. I generally don't use it since it's something...
"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
August 31, 2015 at 6:40 am
Since we can't see the query we're only making vague suggestions, but while on that track, another thing to look at is your Cost Threshold for Parallelism. The default value...
"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
August 31, 2015 at 4:35 am
Yeah, have to agree with this one. If you are in a situation where an ID/Value approach is going to work better, get the heck out of an RDBMS like...
"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
August 31, 2015 at 4:32 am
Glad to help.
The one piece of advice I'd give is that you need to get everyone using a fairly common approach. If some are only doing partial work, 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
August 28, 2015 at 3:28 pm
diegosiao (8/27/2015)
To a "from zero" robust corporative application, I think code-first oriented modeling is a good approach, taking advantage of the SQL script generation to revise it and 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
August 28, 2015 at 12:45 pm
ZZartin (8/28/2015)
Jeff Moden (8/27/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
August 28, 2015 at 12:42 pm
I've been working with it since the beginning. It's actually... just functional. Most of what you need to do is just there. Yeah, there are some limits, but you'd be...
"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
August 27, 2015 at 4:36 pm
diegosiao (8/27/2015)
I am little confused about the meaning of your replica.
ORM actually stands...
"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
August 27, 2015 at 11:49 am
Viewing 15 posts - 5,626 through 5,640 (of 22,219 total)