Viewing 15 posts - 6,031 through 6,045 (of 22,221 total)
If I'm understanding the question, you just need to use RESTORE ... WITH MOVE. There are samples at the link. Using WITH MOVE will allow you to rename the data...
"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:14 am
If you're returning 45,000 rows out of a 197,000 row table, That's approximately 25% of all the data in the table. The fastest way for it to perform that will...
"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:11 am
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
Viewing 15 posts - 6,031 through 6,045 (of 22,221 total)