Viewing 15 posts - 13,816 through 13,830 (of 22,232 total)
I'll pile on to this one a bit.
Should it be removed? Hell no! As others have already pointed out, there are legitimate reasons to shrink databases, especially in 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
December 10, 2010 at 5:56 am
jcrawf02 (12/9/2010)
Brandie Tarvin (12/9/2010)
Brandie Tarvin (12/9/2010)
SQL Myths Debunked / ReBunked webcast link as requested.
Anytime a webinar is "sponsored" by a company, there's twenty minutes of advertising at the end.
Didn't...
"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
December 9, 2010 at 5:14 pm
I'd start with clustered indexes on the most select and most used column or columns. Then add non-clustered indexes from there. Remember if the key in a cluster covers 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
December 9, 2010 at 12:31 pm
Steve Jones - SSC Editor (12/9/2010)
Grant Fritchey (12/9/2010)
Jack Corbett (12/8/2010)
"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
December 9, 2010 at 11:31 am
Keith Mescha (12/9/2010)
"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
December 9, 2010 at 8:37 am
Holy crud. This is excellent stuff! Well done. I don't think I've seen it all put together quite so succinctly. Thanks.
"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
December 9, 2010 at 6:05 am
traughberk (12/8/2010)
No problem. Yep, I did accidentally leave the Unique flag checked. I've decided I'm going to create an identity column to help with indexing.
You don't necessarily want...
"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
December 9, 2010 at 6:00 am
Alvin Ramard (12/8/2010)
Got a WordPress question for those that do their own administration:Do you let it do automatic updates?
I would if I could. I have to go into the GoDaddy...
"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
December 9, 2010 at 5:53 am
Jack Corbett (12/8/2010)
GilaMonster (12/8/2010)
Jack Corbett (12/8/2010)
"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
December 9, 2010 at 5:45 am
Jack Corbett (12/8/2010)
"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
December 9, 2010 at 5:43 am
I can't say, absolutey yes, or absolutely no. It's probably worth the experiment. But, remember, as far as indexing the view goes, you can only create that cluster. If 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
December 8, 2010 at 1:21 pm
traughberk (12/8/2010)
I will be linking to the view in MS Access and users will be writing queries against the view. They'll be doing some filtering and aggregating.
Then you're going...
"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
December 8, 2010 at 10:51 am
No, that's manipulating the Management Studio UI and it isn't possible. There is not "folders" within the database to differentiate between tables, etc., anyway. If you're trying to control storage,...
"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
December 8, 2010 at 8:47 am
When do you think it might be appropriate to denormalize?
"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
December 8, 2010 at 8:37 am
Do you have a baseline of existing performance on the server? If not, define "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
December 8, 2010 at 8:37 am
Viewing 15 posts - 13,816 through 13,830 (of 22,232 total)