Viewing 15 posts - 13,816 through 13,830 (of 22,224 total)
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
To do that properly, so that the user doesn't get access, you need to open up a programming language, VB, C#, whatever, and create an executable.
Otherwise, a simple solution would...
"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:46 am
Unless you've done modifications to it (in which case, you really should have a tested backup around that you can restore from) model is generic. Do you have another instance...
"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:44 am
GSquared (12/7/2010)
Steve Jones - SSC Editor (12/7/2010)
Brandie Tarvin (12/7/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 7, 2010 at 12:30 pm
Viewing 15 posts - 13,816 through 13,830 (of 22,224 total)