Viewing 15 posts - 5,251 through 5,265 (of 22,219 total)
Steve Jones - SSC Editor (1/8/2016)
Your article today compels me to seek your “Unsubscribe”...
"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
January 9, 2016 at 4:19 pm
I'm with Kevin, this is probably a very involved situation.
However, to at least get you started, I'd look at sys.dm_os_wait_stats to understand what is causing the system to run slow....
"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
January 8, 2016 at 6:45 am
Yeah, I too thought the keys were stored at the leaf level. I'm positive Gail knows that. It must be a misstatement or misinterpretation of what she said.
"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
January 8, 2016 at 6:40 am
That's not something I've seen, so I don't have an explanation for it. Have you patched your SSMS installation? Assuming SSMS is running locally, even if you've regularly patched 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
January 8, 2016 at 6:38 am
I'm with Hugo and Lowell. I'll just offer an alternative to using Ola's scripts (nothing wrong with them, I just like choices). You could check out MinionWare[/url]. They have a...
"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
January 7, 2016 at 8:15 am
You can absolutely do it on your own. Performance Monitor, perfmon.exe, is the first thing to start with. You can capture system and SQL Server specific metrics from that. Next...
"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
January 7, 2016 at 8:12 am
I can also strongly support using Minion Reindex. It's free from MinionWare[/url]. It does an excellent job of managing indexes & statistics.
"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
January 7, 2016 at 8:08 am
Roughly the same execution plans really translates as, different execution plans. As Gail says, look to the row estimates to understand where the differences are coming from.
"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
January 7, 2016 at 8:06 am
It really depends on what you're doing with that data. If you're doing any kind of filtering or joining against it, then the table variable structure that the table valued...
"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
January 6, 2016 at 12:46 pm
In addition to what's already mentioned, I'll add Itzik Ben Gan's book, Inside T-SQL Querying.
Additionally, because taking multiple approaches to learning is always best, I'd suggest tracking down your local...
"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
January 6, 2016 at 8:14 am
Brandie Tarvin (1/4/2016)
Eirikur Eiriksson (1/4/2016)
Koen Verbeeck (1/4/2016)
A bit late, but best wishes for everyone!BLTN:-D
😎
BLT... Nom. Now I'm hungry.
Oh, wait. Wrong thread. Thought we were doing Random Words here for a...
"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
January 4, 2016 at 10:40 am
Andy Warren (1/4/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
January 4, 2016 at 10:39 am
Walter Levy (1/4/2016)
Kind of sad to hear that Toshiba isn't the sterling laptop vendor they once were.
Steve & I bought the same model about a month apart. Mine is older...
"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
January 4, 2016 at 10:37 am
My problem with the Mac is that I truly hate the OS. I guess if I were shopping (and I'm not, and hope not to be for at least one...
"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
January 4, 2016 at 7:44 am
That's extremely abnormal. If it's not a window out of focus as defined above, there must be something wrong on your machine. Check the error logs and try uninstalling unnecessary...
"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
January 4, 2016 at 5:57 am
Viewing 15 posts - 5,251 through 5,265 (of 22,219 total)