Viewing 15 posts - 9,526 through 9,540 (of 22,224 total)
Jeff Moden (9/23/2013)
Grant Fritchey (9/23/2013)
"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
September 23, 2013 at 8:20 am
Rolled out an explosive. It could be a lady finger or a nuclear bomb. Curious how it's going to go off. Stand by for a fizzle or a big bang.
"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
September 23, 2013 at 7:41 am
hisakimatama (9/20/2013)
"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
September 20, 2013 at 10:43 am
steve.fortner 92896 (9/19/2013)
"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
September 19, 2013 at 3:51 pm
steve.fortner 92896 (9/19/2013)
"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
September 19, 2013 at 3:36 pm
steve.fortner 92896 (9/19/2013)
Grant Fritchey (9/19/2013)...Which is why I would do everything in my power to always bypass the HR department.
And just how are you going to do that?
Instead of applying...
"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
September 19, 2013 at 3:16 pm
TravisDBA (9/19/2013)
"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
September 19, 2013 at 3:06 pm
T.Ashish (9/18/2013)
So, should I conclude that I do not have to rely on Execution Plan for optimization of my query. Instead, I should check it only for...
"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
September 19, 2013 at 5:58 am
And SQL Server 7.0 is self-tuning and eliminates the need for a DBA...
Been there. Done that. Got the t-shirt, the tattoo, the brand, the piercing, the secret handshake and 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
September 18, 2013 at 8:26 am
You shouldn't have to get that for restricted user in order to use the immediate rollback.
"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
September 18, 2013 at 7:18 am
I'm not a fan of killing sessions, but, instead of loading them into a temp table and then, presumably, using a cursor to clean them out, what about just using...
"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
September 18, 2013 at 7:04 am
T.Ashish (9/18/2013)
What I have learn is, we have a "estimated plan" and a "actual plan". When we execute a query, SQL gives us the actual plan of what 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
September 18, 2013 at 6:57 am
Yep, validated. Mirroring is still there in 2014.
You can see a listing of the deprecated features here. There are some that will be immediately removed in 2014 and there...
"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
September 18, 2013 at 6:43 am
If by working and not working you mean that putting in single user mode sometimes works better with a single batch than with multiple batches it's down to time 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
September 18, 2013 at 6:37 am
Beatrix Kiddo (9/18/2013)
... also the SQL Server Service Account is in the Administrators' group on the server.
The Agent can be running under a different account. Check 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
September 18, 2013 at 6:35 am
Viewing 15 posts - 9,526 through 9,540 (of 22,224 total)