Viewing 15 posts - 10,891 through 10,905 (of 22,219 total)
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
I've hit similar issues in the past. What we found was that there was a system backup software that was monitoring the files and reading them as we created them....
"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:51 am
reks12 (5/14/2012)
but write me page were i can find that questioni just want to learn that program
maybe to pass exam
please dont be angry
:crying:
Not in any way angry. Sorry if 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 14, 2012 at 9:05 am
Eugene Elutin (5/14/2012)
BTW, the only way to see the questions legally is to take the test. Any other way you're "seeing the questions" is illegal. We absolutely won't help you...
"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 14, 2012 at 8:55 am
HowardW (5/14/2012)
You can find out if Session ID is unique at any given...
"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 14, 2012 at 7:58 am
reks12 (5/14/2012)
i have some page for that question but it ask me to download it
i want to see question with download it on my pc
that page...
"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 14, 2012 at 7:57 am
Viewing 15 posts - 10,891 through 10,905 (of 22,219 total)