Viewing 15 posts - 18,691 through 18,705 (of 22,226 total)
I'm sorry, but I don't understand the structure. What relates one table to another? How would you join table1 to table2 to get the results you want. What does table3...
"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
January 19, 2009 at 6:35 am
I don't see why you both couldn't write an article on the same topic. With your different backgrounds, knowledge sets and approaches I'll bet both would offer up unique information....
"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
January 19, 2009 at 6:33 am
rferguson (1/18/2009)
"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
January 19, 2009 at 6:14 am
office (1/18/2009)
"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
January 18, 2009 at 2:52 pm
Jack Corbett (1/18/2009)
"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
January 18, 2009 at 2:46 pm
In fact, you'd probably hurt performance with just an index on Event, depending on where the cluster index is on the table (if there's a clustered index) because you're likely...
"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
January 18, 2009 at 12:40 pm
In addition to the web sites Gail provided (and the storage engine web site from Microsoft is just fantastic), you might want to read through Kalen Delany's book on 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
January 18, 2009 at 12:38 pm
Steve Jones - Editor (1/18/2009)
"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
January 18, 2009 at 10:32 am
RBarryYoung (1/17/2009)
Is this the one you mean? http://www.sqlservercentral.com/articles/Miscellaneous/2645/
Wow! That is good. I must have missed it the first time round. I agree with the herd on this one Steve, you...
"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
January 18, 2009 at 6:30 am
Ninja's_RGR'us (1/17/2009)
Since when reading the full question a requirement of posting an answer?
😀
Maybe it's time 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
January 17, 2009 at 5:11 am
GilaMonster (1/17/2009)
http://www.sqlservercentral.com/Forums/FindPost638650.aspx
Question was "I didn't start an explicit transaction, I don't have a backup, how do...
"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
January 17, 2009 at 5:09 am
Jean-François Bergeron (1/16/2009)
Why? Is it quicker to do a coalesce over a IsNull?And why not in a where clause?
Cheers,
J-F
It's just because I find COALESCE easier to read. I don't think...
"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
January 16, 2009 at 1:08 pm
gyessql (1/16/2009)
Ya, you are right Grant. I was thinking in terms of Course_desc (considering it being unique) and AccountId, totally forgot about CourseID. My bad!!
But if he did go 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
January 16, 2009 at 1:06 pm
Can you post the execution plan for the original 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
January 16, 2009 at 12:55 pm
When you're not using it in a WHERE clause or a JOIN, COALESCE
"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
January 16, 2009 at 12:54 pm
Viewing 15 posts - 18,691 through 18,705 (of 22,226 total)