Viewing 15 posts - 12,076 through 12,090 (of 22,219 total)
Have you checked the execution plan?
From the looks of things, it's going to be scanning the temp table because you don't have indexing there. As data sizes grow, performance will...
"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 14, 2011 at 5:16 am
The different types of JOIN operations are not interchangeable. They mean, and do, different things. You need to focus on that first. Changing the JOIN type as a means 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
August 14, 2011 at 5:13 am
No one knows for sure. The thing is, everything is not going to move out of all companies, but the trend is towards more & more stuff in the cloud....
"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 14, 2011 at 5:05 am
Just remember that if you turn the query into a stored procedure and you use parameters, you're more likely to get the plan similar to when you hard code 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
August 14, 2011 at 4:56 am
Hey guys, want a free little toy from Red Gate? It's called Tab Magic and remembers what tabs you had open when you close SSMS. Kinda cool. A product 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
August 12, 2011 at 7:38 am
Jeff Moden (8/12/2011)
Grant Fritchey (8/11/2011)
Brandie Tarvin (8/11/2011)
Grant Fritchey (8/11/2011)
Well done Brandie. The only real author I know and we still haven't met.
I think it's hilarious that you think you're 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 12, 2011 at 7:37 am
Why would you set up your security that way? Maybe I'm just lazy but 3-5 roles is generally all that's needed and you just move the users in & out...
"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 12, 2011 at 5:27 am
Lynn Pettis (8/11/2011)
I was going to wait until tomorrow night, but it is close enough.
I am resigning...
"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 11, 2011 at 5:59 pm
A disk queue of 300? YIKES!
"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 11, 2011 at 1:26 pm
Brandie Tarvin (8/11/2011)
Grant Fritchey (8/11/2011)
Well done Brandie. The only real author I know and we still haven't met.
I think it's hilarious that you think you're not a real author.
You're writing,...
"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 11, 2011 at 12:45 pm
I wouldn't expect it to behave like that, no. Yeah, I'd expect a slow-down as there absolutely would be contention on the resources, but not something at that magnitude. That...
"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 11, 2011 at 11:32 am
Well done Brandie. The only real author I know and we still haven't met.
"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 11, 2011 at 11:28 am
I'd like to recommend you get a copy of this book. And then a copy of this one. They cover what you're asking.
"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 11, 2011 at 6:13 am
Yeah, set up a role with all appropriate permissions and then add the users to that. Then you don't have to transfer rights from one user to the next. That's...
"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 11, 2011 at 6:12 am
While I'd prefer you run out & buy 50 or 60 copies of Red Gate SQL Monitor[/url] (my employer), you might be able to get a quick & easy report...
"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 11, 2011 at 6:08 am
Viewing 15 posts - 12,076 through 12,090 (of 22,219 total)