Viewing 15 posts - 7,351 through 7,365 (of 22,219 total)
Yep, what Gail says. It's also in my signature below my posts.
"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
October 17, 2014 at 5:52 am
Koen Verbeeck (10/17/2014)
Grant Fritchey (10/17/2014)
And might I add, it was odd seeing my name as a topic. Ha!Who knew you'd get this popular? 😀
All thanks to those photos with 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
October 17, 2014 at 4:01 am
Best of luck on the project. There are a lot of third party tools already filling this niche in various ways, just so you know.
"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
October 17, 2014 at 3:50 am
Hard to make suggestions based on simply suggesting the number of jobs that a system can support. I've seen systems support outrageously high numbers of jobs, but the jobs were...
"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
October 17, 2014 at 3:48 am
Also remember that changes in the optimizer from one version of SQL Server to the next can result in different query behavior. Most of the time you only see issues...
"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
October 17, 2014 at 3:44 am
It really depends on what you're trying to do. If you need all records from table and only those that match from the other, LEFT JOIN is the way 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
October 17, 2014 at 3:27 am
And might I add, it was odd seeing my name as a topic. Ha!
"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
October 17, 2014 at 3:24 am
I try to use lanyrd.com to track upcoming events. I think I'm a little behind on that at the moment. I do post upcoming events on my blog as well....
"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
October 17, 2014 at 3:20 am
Joy Smith San (10/16/2014)
Grant Fritchey (10/16/2014)
The size of the indexes is much more of a question than the number of them.
Thank you.
So if I have multiple unwanted indexes, obviously...
"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
October 17, 2014 at 3:08 am
The other option is to simply throw hardware at the problem, but that's very expensive and of limited utility. You're going to have to convince people about the realities 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
October 17, 2014 at 3:07 am
I'd raise a stink internally. You can't work miracles. There are physical limitations to the universe and a query without a WHERE clause is going to smack right into them...
"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
October 16, 2014 at 4:02 pm
Random or not, they're ugly to read.
"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
October 16, 2014 at 8:03 am
If updating the indexes doesn't work, try updating the statistics, possibly with FULL SCAN.
"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
October 16, 2014 at 6:52 am
Possibly a change in indexes? Statistics are out of date or missing? Check the execution plan. It sure sounds like the optimizer is making some poor choices in executing this...
"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
October 16, 2014 at 6:40 am
I've got nothing either. You'd think, logically, adding additional AND logic would result in further filtering, not the addition of more data.
"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
October 16, 2014 at 4:22 am
Viewing 15 posts - 7,351 through 7,365 (of 22,219 total)