Viewing 15 posts - 6,031 through 6,045 (of 22,211 total)
Take a look at the execution plan for the query. That will tell you what's happening with it. DISTINCT is an aggregation command. To get the best performance out of...
May 22, 2015 at 2:59 am
TomThomson (5/21/2015)
Have a look at this one. To me it looks like a recipe for disaster.
Or, we could just set fire to the server room and watch it...
May 21, 2015 at 6:03 pm
There are lots and lots of issues here, but speaking from personal experience, let me tell you what the #1 biggest problem is going to be.
You're going to have X...
May 21, 2015 at 6:02 pm
A deadlock won't lock people out. It'll error out. Do you mean you have blocking?
And as for resolving deadlocks, it's usually a series of things. You have to get the...
May 21, 2015 at 12:18 pm
Eric M Russell (5/21/2015)
If you feel confident that this particular query should always leverage the non-clustered columnstore index, then have you tried an index like so?
WITH (INDEX (IX_EmployeeReview_CS))
But the issue...
May 21, 2015 at 12:12 pm
I'm not sure. I don't have a good answer to that.
May 21, 2015 at 11:33 am
GilaMonster (5/21/2015)
Grant Fritchey (5/21/2015)
Anti-virus
VM configuration
Server configuration (no NOT memory, I suspect something CPU related)
Queries that have always caused pain...
May 21, 2015 at 10:18 am
jasona.work (5/21/2015)
Grant Fritchey (5/21/2015)
jasona.work (5/21/2015)
If I bring up the fact that I've not read The Thread from start to finish, does my secret SSC decoder ring get taken away?:w00t:
Duh!
Yes.
...yawa nekat...
May 21, 2015 at 10:06 am
Yeah, I've installed them and used them successfully. They're great, if terribly fiddly. These would only ever get installed in test or development systems. There's no need, nor should there...
May 21, 2015 at 9:40 am
Check the execution plan. It really comes down to have it's being resolved. If you read the FAQ from Microsoft it outlines places where you can revert to row mode...
May 21, 2015 at 9:35 am
Greg Edwards-268690 (5/21/2015)
Have you ever seen I/O contention lead to high CPU usage?
I ran into this on a host they decided to use for all nightly backups at a...
May 21, 2015 at 9:28 am
jasona.work (5/21/2015)
If I bring up the fact that I've not read The Thread from start to finish, does my secret SSC decoder ring get taken away?:w00t:
Duh!
Yes.
May 21, 2015 at 9:21 am
Brandie Tarvin (5/21/2015)
Lynn Pettis (5/21/2015)
cunningham (5/21/2015)
soooo this is where you lot go to blow off steam!
Welcome to The Thread! Now that you are here, you really should spend a...
May 21, 2015 at 9:20 am
One of your top queries is from Activity Monitor. You should probably not have it open all the time. You're actually adding load to the server by doing that.
Let...
May 21, 2015 at 4:56 am
artisticcheese (5/20/2015)
Grant Fritchey (5/20/2015)
May 20, 2015 at 4:57 pm
Viewing 15 posts - 6,031 through 6,045 (of 22,211 total)