Viewing 15 posts - 5,671 through 5,685 (of 22,227 total)
I'm with Sean. It sure sounds like normalization might be an issue. I'd focus there as well.
In terms of impact of adding a column, it depends. If you're talking about...
"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 25, 2015 at 4:50 am
doug 88182 (8/24/2015)
I have 40 servers.
Each server has a [dbadb] database.
Each database has a view named v_DatabaseFiles that shows information on the database files...
"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 24, 2015 at 3:36 pm
Jeff Moden (8/24/2015)
Grant Fritchey (8/24/2015)
Threadizens, please don't skip posting your top scripts. I need help on this article.
I thought you just wanted commands. As for "top scripts", I'm not...
"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 24, 2015 at 11:04 am
Steve Jones - SSC Editor (8/24/2015)
Wow some great lists. This might be a good thread to compile into an article.
Ha! That's the plan, but I'm wondering now if I should...
"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 24, 2015 at 10:58 am
I don't know. That's weird. But the site seems a little off today. A disturbance in the force perhaps.
"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 24, 2015 at 8:26 am
In over 20 years working with SQL Server, I've only ever seen the OS files defragmented in handful of cases. Most of the time if you build your database files...
"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 24, 2015 at 6:25 am
Threadizens, please don't skip posting your top scripts. I need help on this article.
"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 24, 2015 at 4:50 am
Without seeing the query, I can't tell what you're running. As Jeff said, if you're using the Maintenance Plan wizard to do this, it's running for all indexes.
For index maintenance,...
"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 24, 2015 at 4:35 am
lgluna20 (8/21/2015)
Thanks you very much for your answer
Sorry in case of the questions number 3 I was not clear about it.
Basically as you know SQL Server include Maintenance...
"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 22, 2015 at 4:35 am
Please don't cross post questions. It just confuses the conversation.
Please post responses to this question over here.
"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 21, 2015 at 12:32 pm
You're basically doing the same thing as a side-by-side upgrade. That's a very straight forward mechanism. Lots of documentation out there on it. You have options and it depends on...
"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 21, 2015 at 12:27 pm
What it does is acts as a marker for if a given row has been updated. So you can read the data, get the current rowversion, then when you go...
"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 21, 2015 at 12:18 pm
Eric M Russell (8/21/2015)
However, the MERGE statement is complicated enough that it could use a GUI...
"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 21, 2015 at 8:49 am
If you want to help out, here's the thread.
"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 21, 2015 at 7:15 am
lgluna20 (8/21/2015)
Thanks for your kind support and answerI want to know
1-Is it necessary to execute update static and rebuild index daily ?
It really depends on your system. Most...
"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 21, 2015 at 6:52 am
Viewing 15 posts - 5,671 through 5,685 (of 22,227 total)