Viewing 15 posts - 14,296 through 14,310 (of 22,227 total)
Because the dependency viewing in SQL Server is more than a little bit messed up. Try running a query against sys.dm_referencing_entities to get the objects that are referring to 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
September 28, 2010 at 6:59 am
The estimated costs are just that, estimates. They're calculations based on the statistics available and the query being run. While they are the only number available to us when working...
"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
September 28, 2010 at 5:48 am
Steve Jones - Editor (9/27/2010)
Jeff Moden (9/27/2010)
...I guess I should look at the more postive "at least people are trying" aspect.
If they are trying. Remember that posts, articles, etc....
"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
September 27, 2010 at 7:22 pm
Alvin Ramard (9/27/2010)
Grant Fritchey (9/27/2010)
Jeff Moden (9/27/2010)
Grant Fritchey (9/27/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
September 27, 2010 at 1:36 pm
Steve Jones - Editor (9/27/2010)
Most sessions are recorded.You could also make an appeal to Allen Kinsel to slide one of you two.
Not me. Allen is overworked as is. He's done...
"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
September 27, 2010 at 1:35 pm
digdave7 (9/27/2010)
Thanks for the reply; you're comments helped. I did want to ask (if you dont mind) for more feedback on the "migrate the keys"...
"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
September 27, 2010 at 1:34 pm
Jeff Moden (9/27/2010)
Grant Fritchey (9/27/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
September 27, 2010 at 1:24 pm
A lady at ASKSSC could use some help. I know you guys don't go there often.
She's, I'd say, being abused by the boss. Might want to chime in.
"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
September 27, 2010 at 12:08 pm
WayneS (9/27/2010)
CirquedeSQLeil (9/27/2010)
Sometimes we learn quite a bit through our articles and our blogs that we would not have learned otherwise.
So true. In fact, the last article that I...
"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
September 27, 2010 at 9:17 am
Steve Jones - Editor (9/27/2010)
Alvin Ramard (9/27/2010)
Jeff Moden (9/26/2010)
... there are a whole lot of people that should'na be allowed near a computer never mind a database.
Seen too many 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
September 27, 2010 at 8:42 am
While we're waiting for more information, a pretty simple rule, if you're moving everything, every time, it's pretty difficult to "tune" the process. You should validate that the amount 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
September 27, 2010 at 6:59 am
Big system or small, the question for me when upgrading the system is, how can I do it safely? What's the best method for protecting the business' data?
The answer 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
September 27, 2010 at 6:56 am
Yes and no. Is it a good idea to understand how common concepts apply across platforms? Sure is. But you can only get so deep on multiple systems. If 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
September 27, 2010 at 6:43 am
Replacing the GUID with an integer, especially on the cluster, is a good idea, but I would not go through that interim step of moving it to varchar first. You're...
"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
September 27, 2010 at 5:43 am
I just got bad news. I've seen the schedule for the PASS Summit. I'll be speaking to an empty room because I'm presenting the same time as Jeff.
Hey Jeff,...
"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
September 27, 2010 at 5:39 am
Viewing 15 posts - 14,296 through 14,310 (of 22,227 total)