Viewing 15 posts - 12,076 through 12,090 (of 22,224 total)
If you loathe technology, don't do it. It's not worth it. I love technology and sometimes hate this job. If I didn't absolutely love the problems I was dealing with...
"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 15, 2011 at 6:00 am
Also, if your servers are getting that out of sync, you might want to reexamine your development and deployment processes. Tools like SQL Compare will help a lot, but having...
"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 15, 2011 at 5:40 am
Some DDL operations are also available in the default trace, but not all.
Otherwise, you need to set up a system for monitoring this ahead of time.
"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 15, 2011 at 5:39 am
You're scanning almost 11 million rows. That's just going to be slow. No way to add some WHERE clauses to the query to limit the result set? Add in 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 6:12 am
I concur. You need to address the root causes, not simply try to limit the size of tempdb. In fact, as you're finding, you won't be able to. If whatever...
"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:18 am
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
Viewing 15 posts - 12,076 through 12,090 (of 22,224 total)