Viewing 15 posts - 6,031 through 6,045 (of 22,219 total)
Do be cautious. If something has been locking a resource because it just didn't have a commit on the transaction, chances are the rollback will be fast. But if it's...
"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
May 26, 2015 at 7:09 am
Another option, if you are in the 2012/2014 realm is to look at Availability Groups. You can have one that is read only and keeping it up to date 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
May 23, 2015 at 5:44 am
Thanks for the feedback. Everyone is pretty much mirroring my opinion on it. I'm not surprised.
"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
May 23, 2015 at 5:12 am
Question for the crew since this is a fairly international audience, plagiarism
I understand that some cultures look at it very differently than most Western European-based ones do. There's the whole...
"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
May 22, 2015 at 9:54 am
Eirikur Eiriksson (5/16/2015)
Still waiting for an answer to the question Why?😎
Can't possibly speak for the OP, but it sure looks like they've got a rats nest of triggers and...
"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
May 22, 2015 at 7:42 am
Jack Corbett (5/22/2015)
My employer just finished a renovation and I'm...
"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
May 22, 2015 at 6:53 am
For the process you have to be blocking itself, you're probably looking at a parallel plan on one or more of the queries involved. Here's what I'd do. First, capture...
"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
May 22, 2015 at 5:56 am
audiocool (5/22/2015)
GilaMonster (5/22/2015)
audiocool (5/22/2015)
is the following service require to turn onSQL Server Analysis Service ?
Are you planning to use it's features? Are you planning to build cubes, do data mining...
"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
May 22, 2015 at 3:24 am
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...
"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
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...
"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
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...
"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
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...
"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
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...
"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
May 21, 2015 at 12:12 pm
I'm not sure. I don't have a good answer to 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
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...
"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
May 21, 2015 at 10:18 am
Viewing 15 posts - 6,031 through 6,045 (of 22,219 total)