Viewing 15 posts - 5,626 through 5,640 (of 22,211 total)
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...
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...
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...
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...
August 28, 2015 at 12:45 pm
ZZartin (8/28/2015)
Jeff Moden (8/27/2015)
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...
August 27, 2015 at 4:36 pm
diegosiao (8/27/2015)
I am little confused about the meaning of your replica.
ORM actually stands...
August 27, 2015 at 11:49 am
diegosiao (8/27/2015)
There is also this free .NET library, which is lightweight and very performatic:
It is a seven year old thread as Gail points out.
But, I have a question, how will...
August 27, 2015 at 10:45 am
ltibbs (8/27/2015)
What would be the purpose of moving the query capability off of the production server?
Wouldn't that just still require granular permissions that would still apply elsewhere?
Looks like...
August 27, 2015 at 7:44 am
Monitoring and performance metrics and tuning. Nothing is ever really running fast enough.
August 27, 2015 at 4:30 am
How are you getting your database objects in and out of TFS? If you're doing it manually, stop.
Microsoft provides a free tool, SQL Server Database Tools. It runs in...
August 27, 2015 at 4:29 am
I would definitely take a look at that query as a candidate for performance tuning.
August 27, 2015 at 4:22 am
Why not use the same document? There are changes between 2008 and 2014, but by and large the underlying tool set for monitoring is roughly the same (you should use...
August 27, 2015 at 4:20 am
SQL Guy 1 (8/26/2015)
Grant Fritchey (8/26/2015)
August 26, 2015 at 8:53 pm
Also, you say you checked the plan, I mean, did you look at the plan when it's running slow to compare it to when it's running fast. If you're hitting...
August 26, 2015 at 12:17 pm
Viewing 15 posts - 5,626 through 5,640 (of 22,211 total)