Viewing 15 posts - 9,526 through 9,540 (of 22,219 total)
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
No, it's not going away after 2012. That's wrong. It's on the deprecation list. The current plans are that once something goes on the deprecation list it should only last...
"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 5:52 am
Just remember that you can only do transaction log backups or full backups with COPY_ONLY on the secondaries. If you're already running everything on the primary and it's not hurting...
"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 5:46 am
I just recently wrote a blog post about execution plan costs[/url]. They are all estimates, not actual measures.
"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 5:44 am
carpainter69 (9/17/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 18, 2013 at 3:18 am
Alex, no question that the format and structure can be an aid to learning. But I remain unconvinced that most people view it that way or use it that 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
September 17, 2013 at 3:48 pm
Viewing 15 posts - 9,526 through 9,540 (of 22,219 total)