Viewing 15 posts - 13,816 through 13,830 (of 22,219 total)
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
vinothraj (12/6/2010)
...Naturally it will join based upon the order you have given...
No, not at all. The natural behavior of the optimizer is to rearrange the join order, right out of...
"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 5:43 am
I hated geometry, so don't look at me. But even if someone could write the function in TSQL, they shouldn't. It's not something that the T-SQL language is going 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
December 6, 2010 at 9:24 am
I guess I'm still confused as to what you're going for, but sQL Server knows which databases it uses to maintain itself. It works with them and there's very little...
"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 6, 2010 at 8:14 am
Yep, what Steve said. Sorry I wasn't clear. It's a domain account that I was describing without saying it properly.
"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 6, 2010 at 8:13 am
No, SQL Server should run as an account on your system that has access to that drive. We usually use a common service account for most of our systems, 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
December 6, 2010 at 7:34 am
Viewing 15 posts - 13,816 through 13,830 (of 22,219 total)