Viewing 15 posts - 13,816 through 13,830 (of 22,227 total)
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
Basically, you set up monitoring to collect information about the system. Based on that information you might set up alerts, emails, etc., in order to proactively respond to situations 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
December 8, 2010 at 8:36 am
jcrawf02 (12/8/2010)
Did you guys see this? Presentation later today on how "shrinking...can be a best practice"? https://www2.gotomeeting.com/register/974801291I signed up to hear what he says.
Yeah, I'm looking forward to that 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
December 8, 2010 at 7:40 am
It really depends on the queries being run against it. As it currently stands, any filter against the view will result in table scans. Actually, as it's configured, any query...
"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 6:06 am
That's a big topic. I'd suggest you take a look at this book (it's a free download) on Team Development[/url] from Red Gate. I wrote the chapters on source control...
"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 6:03 am
Attach is faster. But that really doesn't cover the question. The real question is what are you doing? Are you moving a database from one server to another? Then detach/attach...
"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 5:59 am
Viewing 15 posts - 13,816 through 13,830 (of 22,227 total)