Viewing 15 posts - 10,891 through 10,905 (of 22,224 total)
Try moving the WHERE clause into the ON clause of the OUTER JOIN.
Also, make sure your statistics are up to date.
"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 17, 2012 at 12:48 pm
Start capturing execution metrics. This will at give you some indications as to what is regularly referenced and what isn't. Be prepared to capture a lot of data though. Since...
"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 17, 2012 at 12:40 pm
The length of time it takes is completely dependent on the resources available, the size of the tables, contention with other processes... the list goes on. There's no easy way...
"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 17, 2012 at 12:37 pm
RBarryYoung (5/17/2012)
Grant Fritchey (5/17/2012)
"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 17, 2012 at 10:13 am
The defaults for the 2012 install should be for traditional. If not, go to Tools, Options, Keyboard & change it to the default. That's one fight with the development team...
"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 17, 2012 at 9:07 am
Gullimeel (5/17/2012)
"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 17, 2012 at 7:58 am
Gullimeel (5/17/2012)
"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 17, 2012 at 7:40 am
Security of their systems, not the ones being built would be why you wouldn't want to give people permission to create stored procs. Still weird.
"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 17, 2012 at 5:37 am
And then what do you do when the distribution of the data changes?
"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 17, 2012 at 5:34 am
The basic idea behind having both is that some people absolutely loathe the conversations that take place here on SSC. So, a place has been provided where a specific question...
"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 17, 2012 at 5:33 am
I know you said the permissions are correct, but when backing up the server, the process doesn't your logins permissions. Instead it uses the permissions of the SQL Server service....
"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 17, 2012 at 5:22 am
Every test I've seen indicates, except in well proven edge cases, you will always receive a benefit from clustered indexes, even on inserts. If you do a search on "Which...
"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 16, 2012 at 6:03 am
The DTA works best, when it works at all, on entire loads. It's not terribly good at tuning individual queries. But if you have six hours worth of capture metrics...
"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 16, 2012 at 6:01 am
The fact that it's intermittent suggests that it may have been running, but you were just missing the windows. Our situation was the same. It actually went away twice on...
"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 15, 2012 at 1:21 pm
Connections was in Vegas in the spring this year. I think that might be permanent. We'll see.
I've presented at both Connections & the PASS Summit. The sessions available at Connections...
"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 15, 2012 at 10:56 am
Viewing 15 posts - 10,891 through 10,905 (of 22,224 total)