Viewing 15 posts - 18,931 through 18,945 (of 22,226 total)
RBarryYoung (12/29/2008)
"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
December 30, 2008 at 5:44 am
You don't have access to system tables in 2005. Those are views that you're seeing.
I wouldn't do something like that on a bet, especially on a production system 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
December 29, 2008 at 1:29 pm
I can't say that I've seen that. Any time I thought it was wrong, upon further investigation, I found that it was correct. For example, maybe your default connection database...
"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
December 29, 2008 at 12:32 pm
joshcsmith13 (12/29/2008)
"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
December 29, 2008 at 11:30 am
emailtoDeepa (12/29/2008)
SELECT master.id, master.field1, child.field1FROM master Left outer JOIN child on master.id = child.masterID
But that is just the same OUTER JOIN that the OP wrote in the first post. What...
"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
December 29, 2008 at 10:33 am
Itzik Ben-Gan has three that I highly recommend:
SQL Server 2008 T-SQL Fundamentals - It's 2008, yes, but it's very introductory and applies almost completely to 2005.
Inside SQL Server 2005:...
"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
December 29, 2008 at 10:29 am
Nah, don't sweat it. I thought it was a strange reply, but I didn't get upset.
I'm still confused by the concept of a thing that is absolutely used for identification...
"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
December 29, 2008 at 6:43 am
Let me first say, this is just my opinion. Others can, and probably will, disagree.
The question for me is, do you want to stay a geek or let those skills...
"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
December 29, 2008 at 6:34 am
If you want to see each statement within a query as it executions use a trace (or Profiler on a non-production system), to capture the statement completion events :SP:StmtCompleted and/or...
"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
December 29, 2008 at 6:26 am
But the WHERE clause in that query will more or less always force an INNER JOIN. If you're filtering by the Child records, then that's what you're filtering by. 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
December 29, 2008 at 6:22 am
Gaby A. (12/24/2008)
dford (12/24/2008)
"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
December 29, 2008 at 6:05 am
Thinking about it a bit more, you could combine older versions. Anything released 10 years ago or more will go into a "Previous Versions" folder with a the same four...
"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
December 29, 2008 at 5:54 am
I agree. Consolidating the forums is a great idea. There really are too many to manage or browse through. I still think you should seperate them by version though. Even...
"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
December 29, 2008 at 5:51 am
Jeff Moden (12/27/2008)
"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
December 29, 2008 at 5:30 am
It looks very good. Nice job.
"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
December 27, 2008 at 5:06 am
Viewing 15 posts - 18,931 through 18,945 (of 22,226 total)