Viewing 15 posts - 18,916 through 18,930 (of 22,219 total)
That procedure might be querying across the databases. It's also possible their login is going to your database by default.
I'm sure it's possible for it to report incorrect connections, but...
"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 31, 2008 at 5:49 am
It may be clunky, but there is a lot of clarity of information by seperating it into discrete buckets (even though the buckets are a bit abused by some 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
December 30, 2008 at 12:51 pm
I would say the difference is probably attributable to statistics. If you look at the end of the process, the scans & reads for the two are VERY different. For...
"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 9:47 am
Larry Larson (12/30/2008)
The Guru's Guide to Transact-SQL, by Ken Henderson.
I agree with this. I have three of Henderson's books sitting on my shelf right now. Unfortunately, they're beginning to age...
"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 7:30 am
Lin Zhang (12/30/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 7:21 am
Yeah, I'd like to see some information too. What the heck are you moving data into tempdb for? SQL Server puts enough of a load onto the tempdb without adding...
"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 6:20 am
Lin Zhang (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 6:04 am
interfac (12/29/2008)
That code returns the correct results that I was looking for!Regards
James
Then I'm really confused. If you drop the WHERE clause, your initial query should have worked.
"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:53 am
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
Viewing 15 posts - 18,916 through 18,930 (of 22,219 total)