Viewing 15 posts - 4,546 through 4,560 (of 22,219 total)
yujinagata72 (8/16/2016)
If I get a query plan XML, what kind of information will make it to be considered as a 'bad' plan?
I can think of the following:
- PhysicalOp="Clustered Index Scan"
-...
"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
August 16, 2016 at 10:24 am
Snargables (8/16/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
August 16, 2016 at 10:20 am
You can capture plans using extended events (or trace, but I wouldn't suggest trace since it's filtering mechanism is so weak and capturing execution plans is so expensive), but be...
"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
August 16, 2016 at 6:25 am
Brandie Tarvin (8/16/2016)
If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I should be warned about?
We're apparently getting 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
August 16, 2016 at 6:24 am
You will see some performance gains, but they're not astronomical.
"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
August 16, 2016 at 6:19 am
Use powershell. You can identify the date and just bring back the ones you need 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
August 16, 2016 at 3:52 am
Fundamentally, a deadlock is a performance issue. If the transactions complete fast enough, you won't see a deadlock. The trick to fixing them is to address both sides. Yeah, 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
August 16, 2016 at 3:50 am
The main difference is over the use of in-row storage. VARCHAR will always have it, VARCHAR(MAX) will bias towards it, but then move to LOB storage when it needs 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
August 16, 2016 at 3:44 am
But only update the column statistics if the automatic statistics updates are not adequate for maintaining 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
August 16, 2016 at 3:33 am
I have an article on how to retrieve information [/url]from your backups that could help. You'll just have to convert that information into what you need for the restore as...
"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
August 16, 2016 at 3:30 am
I have done this kind of work before. It's somewhat difficult. Basically you have to arrive at a mechanism to version the data as it goes in. I have some...
"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
August 16, 2016 at 3:27 am
ThomasRushton (8/15/2016)
ChrisM@Work (8/15/2016)
ThomasRushton (8/15/2016)
Grant Fritchey (8/15/2016)
Hey Threadizens!Grant!
Damn. Now I want to watch some Cheers.
Gosh never mind the telly, where's the best curry around here?
It depends. (sorrynotsorry).
Where are 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
August 15, 2016 at 7:03 am
Hey Threadizens!
India was lovely, terrifying, interesting, frustrating and great, all at once. I've taken more selfies with people on this one trip than I had done in my entire life...
"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
August 15, 2016 at 5:46 am
That guy is really lazy and has not written a book on 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
August 11, 2016 at 4:57 am
ChrisM@Work (8/5/2016)
Grant Fritchey (8/5/2016)
BLOB_EATER (8/5/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
August 5, 2016 at 8:35 am
Viewing 15 posts - 4,546 through 4,560 (of 22,219 total)