Viewing 15 posts - 6,781 through 6,795 (of 22,226 total)
It does depend on the query you're running against the DMVs, but, generally, those are very lightweight, so it should be fine. The nice thing about them is that 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
February 5, 2015 at 11:52 am
"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
February 5, 2015 at 11:43 am
Sioban Krzywicki (2/5/2015)
Grant Fritchey (2/5/2015)
Brandie Tarvin (2/5/2015)
I didn't even know this was a thing, but...
"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
February 5, 2015 at 10:30 am
Jack Corbett (2/5/2015)
"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
February 5, 2015 at 9:39 am
Brandie Tarvin (2/5/2015)
So I just got a workplace reminder to wear red tomorrow because of National Red Day[/url].I didn't even know this was a thing, but it is. Wanna participate?
Eh....
"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
February 5, 2015 at 9:37 am
Brandie Tarvin (2/5/2015)
Sioban Krzywicki (2/5/2015)
Grant Fritchey (2/5/2015)
Brandie Tarvin (2/5/2015)
Do you agree...
"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
February 5, 2015 at 7:45 am
Sioban Krzywicki (2/5/2015)
Grant Fritchey (2/5/2015)
Brandie Tarvin (2/5/2015)
Do you agree or disagree...
"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
February 5, 2015 at 7:33 am
If you don't update your statistics the optimizer will make bad choices for your query plans. This can seriously negatively impact performance. So, large database or not, you have 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
February 5, 2015 at 7:09 am
Brandie Tarvin (2/5/2015)
Do you agree or disagree that trick questions are...
"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
February 5, 2015 at 6:47 am
Cody K (2/5/2015)
Yes the graphs are definitely the same. I mean it's not the same row/page but they're all on the same table, same queries, same combination of indexes.
Perfect. Then...
"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
February 5, 2015 at 5:48 am
right, the object definition.
"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
February 5, 2015 at 5:48 am
Yeah, it's really an issue with the servers and their configuration.
But, that's not to say that tuning won't help. Reduce the amount and number of reads you need and then...
"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
February 5, 2015 at 4:51 am
One option is to hang your shingle as it were on a blog. I know a lot of people who get work 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
February 5, 2015 at 4:49 am
Everything Dwain has said so far is spot on.
So, to your first question, is it ok and will it help performance to defragment your indexes daily.
Sure. If you have 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
February 5, 2015 at 4:45 am
You basically have to rebuild the table, twice. Once to remove the old clustered index and once to add the new 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
February 5, 2015 at 4:36 am
Viewing 15 posts - 6,781 through 6,795 (of 22,226 total)