Viewing 15 posts - 4,831 through 4,845 (of 22,227 total)
What the heck is this doing in the JOIN criteria:
0 = 1
and pbu.bu_id is not null
I gave up after that. I'm not paid enough.
Instead of NOLOCK on umpti-gazillion tables, why...
"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
April 15, 2016 at 11:12 am
What about the row estimates between the servers. Are they the same? You're getting a different memory grant because the optimizer thinks it's moving different amounts of data (and in...
"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
April 15, 2016 at 9:27 am
Brandie Tarvin (4/15/2016)
Grant Fritchey (4/15/2016)
and, more recently:
How to recover from deleting everything, including the backups
I sincerely hope that this data is not vital to your...
"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
April 15, 2016 at 8:10 am
Another vote for distributed replay. That's how I've done this sort of testing.
"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
April 15, 2016 at 7:11 am
There are absolutely optimizer differences between 2008 & 2012. The cardinality estimator is not different. That's what those traceflags in 2014 are for. It's not applicable to 2012 where 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
April 15, 2016 at 7:08 am
It sounds like the process may be running still. It could be blocked by some other process. Have you checked blocking? Use sys.dm_exec_requests to see what processes are actively running,...
"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
April 15, 2016 at 7:04 am
Add the index.
A lot of the recommendations for SharePoint databases are not correct. Do what you know is the right thing, deal with Microsoft support if you have to.
However,...
"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
April 15, 2016 at 7:01 am
Backups. What are they good for?[/url]
and, more recently:
How to recover from deleting everything, including the backups
I sincerely hope that this data is not vital to your organization, because it's gone.
"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
April 15, 2016 at 6:39 am
jeff.mason (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspxI don't have backup.
In 2016, with all of the available training, documentation, and general awareness and people STILL aren't taking backups?
Or, nuking the offsite backups along 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
April 15, 2016 at 6:35 am
Sean Lange (4/14/2016)
Oh that's right. It should be
;select
BURN IT WITH FIRE!!!!
"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
April 14, 2016 at 2:35 pm
Jeff Moden (4/14/2016)
"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
April 14, 2016 at 2:34 pm
This is a major tuning effort. I'd definitely be able to say more if I could see the execution plan. However, the other comments, JOINs on views, what appears to...
"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
April 14, 2016 at 8:02 am
Hopefully you have backups in place. You may need to go to these and be prepared to do a page level restore. This is not an easy operation. Practice several...
"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
April 14, 2016 at 7:59 am
I've seen this argument before, and I actually lean towards what Jeff & Brent are advocating... if your queries are primarily seek. If you've tuned the system so you're largely...
"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
April 14, 2016 at 7:38 am
I agree with Jeff, it depends.
However, let's say Staging is really Staging, a place to validate deployments prior to production. Then no. I wouldn't have backups at all.
If they'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
April 13, 2016 at 2:53 pm
Viewing 15 posts - 4,831 through 4,845 (of 22,227 total)